ㅋㄷㅋㄷ

-- 코드를 입력하세요SELECT MONTH(START_DATE) AS MONTH, CAR_ID,COUNT(*) AS RECORDSFROM CAR_RENTAL_COMPANY_RENTAL_HISTORYWHERE 1=1 AND START_DATE BETWEEN '2022-08-01' AND '2022-10-31' AND CAR_ID IN (SELECT CAR_ID FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE 1=1 AND START_DATE BETWEEN '2022-08-01' AND '2022-10-31' GROUP BY CAR_ID..

order by, limit을 이용할 수 있지만 max 함수 이용해서 출력하기 SELECT *FROM FOOD_PRODUCTWHERE 1=1 AND PRICE = (SELECT MAX(PRICE) FROM FOOD_PRODUCT)

SELECT WAREHOUSE_ID, WAREHOUSE_NAME, ADDRESS, IFNULL(FREEZER_YN, 'N') AS FREEZER_YNFROM FOOD_WAREHOUSEWHERE 1=1 AND ADDRESS LIKE '%경기%'ORDER BY WAREHOUSE_ID ASC