루시와 엘라 찾기

 

A373219	Cat	2014-07-29 11:43:00	Normal	Ella	Spayed Female
A377750	Dog	2017-10-25 17:17:00	Normal	Lucy	Spayed Female
A353259	Dog	2016-05-08 12:57:00	Injured	Bj	Neutered Male
A354540	Cat	2014-12-11 11:48:00	Normal	Tux	Neutered Male
A354597	Cat	2014-05-02 12:16:00	Normal	Ariel	Spayed Female

SQL문을 실행하면 다음과 같이 나와야 합니다.

 

ANIMAL_ID                                                     NAME                                 SEX_UPON_INTAKE

A373219	Ella	Spayed Female
A377750	Lucy	Spayed Female

 

나의 코드)

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