[SQL문제풀기] 있었는데요 없었습니다(JOIN)

Q.

풀이

select b.animal_id, b.name
from animal_ins as b
join animal_outs as a on a.animal_id = b.animal_id
where a.datetime < b.datetime
order by b.datetime asc;