Lv2. 루시와 엘라 찾기

▶ 문제

 

▶ 풀이방법

- 첫번째 풀이방법

SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKE
FROM ANIMAL_INS
WHERE NAME = "Lucy" OR NAME = "Ella" OR NAME = "Pickle" OR NAME = "Rogan" OR NAME = "Sabrina" OR NAME = "Mitty";

 

- 두번째 풀이방법

SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKE
FROM ANIMAL_INS
WHERE NAME in ("Lucy","Ella","Pickle","Rogan","Sabrina", "Mitty");

- in함수 : 포함하고 있는것