zimslog

처음 정답 코드)-- 생산일자 22.5-- id, name, 총매출-- order by 총매출 desc, id ascSELECT F.PRODUCT_ID, F.PRODUCT_NAME, F.PRICE*O.AMOUNT AS TOTAL_SALESFROM FOOD_PRODUCT FJOIN (SELECT PRODUCT_ID, SUM(AMOUNT) AS AMOUNTFROM FOOD_ORDERWHERE DATE_FORMAT(PRODUCE_DATE,'%Y-%m') = '2022-05'GROUP BY PRODUCT_ID) OON F.PRODUCT_ID = O.PRODUCT_IDORDER BY TOTAL_SALES DESC, PRODUCT_ID ASC

프로그래머스 - 특정 기간동안 대여 가능한 자동차들의 대여비용 구하기 1. 처음 정답 코드WITH PLIST AS (SELECT *FROM CAR_RENTAL_COMPANY_CAR CWHERE C.CAR_TYPE IN ('세단','SUV') AND C.CAR_ID NOT IN (SELECT H.CAR_ID FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY H WHERE NOT (END_DATE '2022-11-30')) ) SELECT L.CAR_ID AS CAR_ID, L.CAR_TYPE AS CAR_TYPE, ROUND(L.DAILY_FEE*30..