select i.animal_id, i.namefrom animal_ins i, animal_outs owhere o.animal_id = i.animal_idand i.datetime>o.datetimeorder by i.datetime

select name, datetimefrom (select animal_id, name, datetime from animal_ins where animal_id not in (select animal_id from animal_outs) order by datetime)where rownum

select animal_id, namefrom (select o.animal_id, o.name, (o.datetime-i.datetime) from ANIMAL_OUTS o,ANIMAL_INS i where o.animal_id=i.animal_id order by (o.datetime-i.datetime) desc)where rownum

SELECT id, name, host_idfrom places awhere (select count(host_id) from places b where a.host_id = b.host_id) >=2order by id

SELECT ORDER_ID, PRODUCT_ID, to_char(out_date,'yyyy-mm-dd') as out_date, case when to_number(to_char(out_date,'yyyymmdd'))20220501 then '출고대기' else '출고미정' end as 출고여부from FOOD_ORDERorder by order_id;

SELECT FOOD_TYPE, REST_ID, REST_NAME, FAVORITESfrom REST_INFOwhere (food_type,favorites) in (select food_type, max(favorites) from rest_info group by food_type)order by food_type desc;

SELECT b.CATEGORY, sum(s.sales) as TOTAL_SALESfrom book b, book_sales swhere b.book_id = s.book_idand to_char(SALES_DATE,'yyyy-mm') ='2022-01'group by b.categoryorder by CATEGORY

SELECT to_number(to_char(start_date,'mm')) as MONTH, CAR_ID, count(*) as RECORDSfrom CAR_RENTAL_COMPANY_RENTAL_HISTORY where to_char(start_date,'yyyy-mm-dd') between '2022-08-01' and '2022-10-31' group by to_char(start_date,'mm'), car_idhaving car_id in (select car_id from CAR_RENTAL_COMPANY_RENTAL_HISTORY where to_char(start_date,'yyyy-mm-dd') between '2..