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);

-- WHERE 절 기본 예제
-- 나이가 20살 이상인 모든 가족들을 조회
SELECT * FROM FAMILY WHERE AGE > 20;
SELECT * FROM FAMILY WHERE HEIGHT < 180;
SELECT * FROM FAMILY WHERE F_NAME = 'HYEON';

--논리 연산자 예제
SELECT * FROM FAMILY WHERE AGE > 20 AND HEIGHT > 170;
SELECT * FROM FAMILY WHERE HEIGHT < 180 OR AGE > 20;
SELECT * FROM FAMILY WHERE NOT AGE > 24;
SELECT * FROM FAMILY WHERE (AGE > 20 OR HEIGHT >165) AND WHO = 'BROTHER';