59043.md

프로그래머스 59043

'있었는데요 없었습니다'

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

SELECT I.ANIMAL_ID, I.NAME
FROM ANIMAL_INS I
JOIN ANIMAL_OUTS O ON I.ANIMAL_ID = O.ANIMAL_ID
WHERE TIMESTAMPDIFF(second, I.DATETIME, O.DATETIME)<0
ORDER BY I.DATETIME