본문 바로가기
카테고리 없음

[SQL/프로그래머스SQL고득점Kit] 오랜 기간 보호한 동물(2) (Level 3)

by Confident Beginner 2023. 1. 27.
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