[프로그래머스] 루시와 엘라 찾기.oracle

[프로그래머스] 루시와 엘라 찾기.Oracle

LV2

 

SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKE
FROM  ANIMAL_INS
WHERE NAME IN('Lucy', 'Ella', 'Pickle', 'Rogan', 'Sabrina', 'Mitty')
ORDER BY ANIMAL_ID;

 

SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKE
FROM  ANIMAL_INS
WHERE NAME LIKE 'Lucy' OR NAME LIKE 'Ella' OR NAME LIKE 'Pickle' OR NAME LIKE 'Rogan' OR NAME LIKE 'Sabrina' OR NAME LIKE 'Mitty'
ORDER BY ANIMAL_ID;