[programmers] MySQL - Lv.3 있었는데요 없었습니다 (join)

문제

 

 

 

 

 

풀이

 

SELECT a.animal_id, a.name
from animal_ins a join animal_outs b
    on a.animal_id = b.animal_id
where a.datetime > b.datetime
order by a.datetime