[프로그래머스, 59043] 있었는데요 없었습니다 (mysql)

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

프로그래머스

728x90

---

SELECT ins.animal_id, ins.name
FROM animal_ins as ins, animal_outs as outs
WHERE ins.animal_id = outs.animal_id AND ins.datetime > outs.datetime
ORDER BY ins.datetime