루시와 엘사 찾기

by SQL

-- 코드를 입력하세요
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

혹은 in 옵션을 이용하여 나열을 할수도 있다

-- 코드를 입력하세요
SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKE
from animal_ins
where name in ('Lucy', 'Ella', 'Pickle','Rogan','Sabrina','Mitty')
order by animal_id