Prerequisite SQL

--기본 데이터 베이스 설정
CREATE TABLE FAMILY( WHO VARCHAR2(10), F_NAME VARCHAR2(10), AGE NUMBER(3), HEIGHT NUMBER(3) ); 
INSERT INTO FAMILY(WHO, F_NAME, AGE, HEIGHT) VALUES('ME', 'HYEON', 24, 181);
INSERT INTO FAMILY(WHO, F_NAME, AGE, HEIGHT) VALUES('FATHER', 'HWAN', 50, 178);
INSERT INTO FAMILY(WHO, F_NAME, AGE, HEIGHT) VALUES('MOTHER', 'JAE', 48, 166);
INSERT INTO FAMILY(WHO, F_NAME, AGE, HEIGHT) VALUES('SISTER', 'MIN', 20, 162);
INSERT INTO FAMILY(WHO, F_NAME, AGE, HEIGHT) VALUES('BROTHER', 'GU', 18, 170);

--SQL연산자 예시
SELECT F_NAME, AGE FROM FAMILY WHERE AGE BETWEEN 18 AND 24; 
SELECT F_NAME FROM FAMILY WHERE AGE IN 18;
SELECT * FROM FAMILY WHERE F_NAME LIKE 'H%'
SELECT F_NAME FROM FAMILY WHERE AGE IS NULL ;

--부정 SQL연산자 예시 직접 만들어보아요!
SELECT F_NAME, AGE FROM FAMILY WHERE AGE BETWEEN 20 AND 29; 
SELECT F_NAME FROM FAMILY WHERE AGE NOT 18;
SELECT F_NAME FROM FAMILY WHERE AGE IS NULL;