SELECT ANIMAL_ID, AI.NAME
FROM ANIMAL_INS AI JOIN ANIMAL_OUTS AO USING (ANIMAL_ID)
WHERE AO.DATETIME IS NOT NULL
ORDER BY (AO.DATETIME - AI.DATETIME) DESC
fetch first 2 rows only;

+ Recent posts