문제 정답 SELECT B.USER_ID, B.NICKNAME, SUM(PRICE) AS TOTAL_SALES FROM USED_GOODS_BOARD AS A JOIN USED_GOODS_USER AS B ON A.WRITER_ID = B.USER_ID WHERE STATUS = 'DONE' GROUP BY A.WRITER_ID HAVING TOTAL_SALES >= 700000 ORDER BY TOTAL_SALES
문제 정답 SELECT MCDP_CD AS '진료과코드', COUNT(MCDP_CD) AS '5월예약건수' FROM APPOINTMENT WHERE DATE_FORMAT(APNT_YMD, '%Y-%m') = '2022-05' GROUP BY MCDP_CD ORDER BY COUNT(MCDP_CD) ASC, MCDP_CD ASC
문제 정답 SELECT CAR_ID, CASE WHEN CAR_ID IN ( SELECT CAR_ID FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE '2022-10-16' BETWEEN START_DATE AND END_DATE ) THEN '대여중' ELSE '대여 가능' END AS AVAILABILITY FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY GROUP BY CAR_ID ORDER BY CAR_ID DESC
문제 정답 SELECT CAR_TYPE, COUNT(CAR_TYPE) 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 A.CATEGORY, SUM(B.SALES) AS TOTAL_SALES FROM BOOK AS A JOIN BOOK_SALES AS B ON A.BOOK_ID = B.BOOK_ID WHERE B.SALES_DATE LIKE '%2022-01%' GROUP BY A.CATEGORY ORDER BY A.CATEGORY
문제 정답 SELECT MONTH(START_DATE) AS MONTH, CAR_ID, COUNT(*) AS RECORDS FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE START_DATE BETWEEN '2022-08-01' AND '2022-10-31' AND CAR_ID IN (SELECT CAR_ID FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE START_DATE BETWEEN '2022-08-01' AND '2022-10-31' GROUP BY CAR_ID HAVING COUNT(CAR_ID) >= 5) GROUP BY CAR_ID, MONTH(START_DATE) ORDER BY MONTH ASC, CAR_ID DESC
문제 정답 SELECT FOOD_TYPE, REST_ID, REST_NAME, FAVORITES FROM REST_INFO WHERE (FOOD_TYPE, FAVORITES) IN (SELECT FOOD_TYPE, MAX(FAVORITES) FROM REST_INFO GROUP BY FOOD_TYPE) ORDER BY FOOD_TYPE DESC
문제 정답 SELECT COUNT(DISTINCT NAME) AS COUNT FROM ANIMAL_INS WHERE NAME != 'NULL' ORDER BY NAME
문제 정답 SELECT COUNT(*) AS COUNT FROM ANIMAL_INS
문제 정답 SELECT MIN(DATETIME) FROM ANIMAL_INS
