-- 코드를 입력하세요
SELECT NAME, DATETIME
FROM ANIMALINS
WHERE ANIMALID NOT IN
(SELECT DISTINCT ANIMALID FROM ANIMALOUTS)
ORDER BY datetime
FETCH NEXT 3 ROWS ONLY;
작성중인 코드―solution.sql
1
2
3
4
5
6
7
-- 코드를 입력하세요SELECTNAME,DATETIMEFROMANIMAL_INSWHEREANIMAL_IDNOTIN(SELECTDISTINCTANIMAL_IDFROMANIMAL_OUTS)ORDERBYdatetimeFETCHNEXT3ROWSONLY;
