[프로그래머스]SQL 오랜 기간 보호한 동물(2)

링크 : 

https://school.programmers.co.kr/learn/courses/30/lessons/59411

프로그래머스

-- 코드를 입력하세요
WITH TBL AS(
SELECT 
    O.ANIMAL_ID AS ANIMAL_ID,
    O.NAME AS NAME,
    O.DATETIME AS OUTDATE,
    I.DATETIME AS INDATE,
    TIMESTAMPDIFF(SECOND,  O.DATETIME, I.DATETIME) AS TIME
FROM
    ANIMAL_OUTS AS O
INNER JOIN
    ANIMAL_INS AS I
ON
    O.ANIMAL_ID = I.ANIMAL_ID
ORDER BY
    TIME
LIMIT
    2
OFFSET
    0
)

SELECT 
    ANIMAL_ID,
    NAME
FROM
    TBL;