Creative Code

SELECT ANIMAL_ID,NAME,SEX_UPON_INTAKE FROM ANIMAL_INS WHERE NAME IN('Lucy','Ella','Pickle','Rogan','Sabrina','Mitty') order by ANIMAL_ID

SELECT B.BOOK_ID, A.AUTHOR_NAME, to_char(B.PUBLISHED_DATE,'YYYY-MM-DD') AS PUBLISHED_DATE FROM BOOK B join AUTHOR A USING(AUTHOR_ID) WHERE B.CATEGORY = '경제' ORDER BY B.PUBLISHED_DATE;

SELECT P.PRODUCT_CODE AS PRODUCT_CODE, SUM(OS.SALES_AMOUNT * P.PRICE) AS SALES FROM PRODUCT P INNER JOIN OFFLINE_SALE OS USING (PRODUCT_ID) GROUP BY PRODUCT_CODE ORDER BY SALES DESC,PRODUCT_CODE;

SELECT CAR_TYPE, COUNT(*) AS CARS FROM CAR_RENTAL_COMPANY_CAR WHERE OPTIONS LIKE '%통풍시트%' OR OPTIONS LIKE '%열선시트%'OR OPTIONS LIKE'%가죽시트%' GROUP BY CAR_TYPE ORDER BY CAR_TYPE;

SELECT MCDP_CD AS "진료과코드", COUNT(*) AS "5월예약건수" FROM APPOINTMENT WHERE to_char(APNT_YMD,'YYYY-MM') = '2022-05' GROUP BY MCDP_CD ORDER BY "5월예약건수", "진료과코드"

SELECT to_number(to_char(DATETIME,'hh24')) AS HOUR,COUNT(to_char(DATETIME,'hh24')) AS COUNT FROM ANIMAL_OUTS WHERE to_char(DATETIME,'hh24') >= 9 AND to_char(DATETIME,'hh24')