select * from(
select NAME, datetime
from( select ANIMALID
from ANIMALINS
minus
select ANIMALID
from ANIMALOUTS
) a join ANIMALINS i
on a.ANIMALID=i.ANIMAL_ID
order by 2
)
where rownum in (1,2,3)
select *
from
(select i.name, i.datetime
from ANIMALINS i left join ANIMALOuts o
on i.ANIMALID = o.ANIMALID
where o.ANIMAL_ID is null
order by 2
)
where rownum<=3