문제 link
https://programmers.co.kr/learn/courses/30/lessons/59411
Code link
https://github.com/JamesJung01/programmers_sql_kit/blob/main/06_STRING%2CDATE/STRING%2CDATE-4.sql
SELECT INS.ANIMAL_ID, INS.NAME FROM ANIMAL_INS AS INS JOIN ANIMAL_OUTS AS OUTS ON INS.ANIMAL_ID = OUTS.ANIMAL_ID ORDER BY DATEDIFF(OUTS.DATETIME, INS.DATETIME) DESC # ORDER BY (OUTS.DATETIME - INS.DATETIME) DESC LIMIT 2