Creative Code

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')

SELECT SUBSTR(PRODUCT_CODE,1,2) AS CATEGORY, COUNT(*) PRODUCTS FROM PRODUCT GROUP BY SUBSTR(PRODUCT_CODE,1,2) ORDER BY CATEGORY;

SELECT ANIMAL_TYPE, COUNT(ANIMAL_TYPE) FROM ANIMAL_INS GROUP BY ANIMAL_TYPE