오랜 기간 보호한 동물(2)(Programmers)

답 쿼리입니다.

WITH T AS (
    SELECT DENSE_RANK() OVER (ORDER BY DATEDIFF(AO.DATETIME, AI.DATETIME) DESC) DENSE_RK
         , AO.ANIMAL_ID
         , AO.NAME
    FROM ANIMAL_INS AI
         JOIN ANIMAL_OUTS AO ON AI.ANIMAL_ID = AO.ANIMAL_ID
)

SELECT ANIMAL_ID
     , NAME
FROM T
WHERE DENSE_RK IN (1, 2)