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

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

프로그래머스

728x90

---

SELECT ai.animal_id, ai.name
FROM animal_ins AS ai
LEFT JOIN animal_outs AS ao ON ai.animal_id = ao.animal_id
ORDER BY (ao.datetime - ai.datetime) DESC LIMIT 2;