SELECT
A.ANIMAL_ID
,A.NAME
# ,A.DATETIME AS 'outdate'
# ,B.DATETIME AS 'indate'
# ,DATEDIFF(A.DATETIME,B.DATETIME )
FROM ANIMAL_OUTS AS A
INNER JOIN ANIMAL_INS AS B ON A.ANIMAL_ID = B.ANIMAL_ID
ORDER BY DATEDIFF(A.DATETIME,B.DATETIME) DESC
LIMIT 2
https://school.programmers.co.kr/learn/courses/30/lessons/59411