🔗 https://school.programmers.co.kr/learn/courses/30/lessons/59411
SELECT I.ANIMAL_ID, I.NAME
FROM ANIMAL_INS I
JOIN ANIMAL_OUTS O ON I.ANIMAL_ID = O.ANIMAL_ID
ORDER BY TIMESTAMPDIFF(second, I.DATETIME, O.DATETIME) DESC
LIMIT 2🔗 https://school.programmers.co.kr/learn/courses/30/lessons/59411
SELECT I.ANIMAL_ID, I.NAME
FROM ANIMAL_INS I
JOIN ANIMAL_OUTS O ON I.ANIMAL_ID = O.ANIMAL_ID
ORDER BY TIMESTAMPDIFF(second, I.DATETIME, O.DATETIME) DESC
LIMIT 2