1. 문제 링크 2, 참조
inner join을 이용한다.
select I.animal_id, I.name from animal_ins as I inner join animal_outs as O on I.animal_id = O.animal_id where O.datetime < I.datetime order by I.datetime