Creative Code

SELECT B.FOOD_TYPE, B.REST_ID, B.REST_NAME, B.FAVORITES FROM (SELECT FOOD_TYPE, MAX(FAVORITES) AS FAVORITES FROM REST_INFO GROUP BY FOOD_TYPE) A, REST_INFO B WHERE A.FOOD_TYPE = B.FOOD_TYPE AND A.FAVORITES = B.FAVORITES ORDER BY A.FOOD_TYPE DESC;

SELECT F.USER_ID, F.NICKNAME, SUM(B.PRICE) AS TOTAL_SALES FROM USED_GOODS_BOARD B, USED_GOODS_USER F WHERE (B.WRITER_ID = F.USER_ID) AND B.STATUS = 'DONE' GROUP BY F.USER_ID, F.NICKNAME HAVING SUM(B.PRICE) >= 700000 ORDER BY TOTAL_SALES;

SELECT B.CATEGORY AS CATEGORY, SUM(BS.SALES) FROM BOOK B, BOOK_SALES BS WHERE B.BOOK_ID = BS.BOOK_ID AND to_char(BS.SALES_DATE,'YYYY-MM') LIKE '2022-01%' GROUP BY B.CATEGORY ORDER BY B.CATEGORY;

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;

SELECT ANIMAL_ID,AI.NAME FROM ANIMAL_INS AI JOIN ANIMAL_OUTS AO USING (ANIMAL_ID) WHERE AI.DATETIME > AO.DATETIME ORDER BY AI.DATETIME;

SELECT AI.NAME AS NAME, AI.DATETIME FROM ANIMAL_INS AI LEFT OUTER JOIN ANIMAL_OUTS AO ON (AI.ANIMAL_ID = AO.ANIMAL_ID) WHERE AO.DATETIME IS NULL ORDER BY AI.DATETIME fetch first 3 rows only;