Level 4

문제

해당 문제 링크

정답

SELECT A.PRODUCT_ID, A.PRODUCT_NAME, A.PRICE*SUM(B.AMOUNT) AS TOTAL_SALES FROM FOOD_PRODUCT A
JOIN FOOD_ORDER B ON A.PRODUCT_ID = B.PRODUCT_ID
WHERE B.PRODUCE_DATE IN (
    SELECT PRODUCE_DATE FROM FOOD_ORDER
        WHERE PRODUCE_DATE LIKE "2022-05%" GROUP BY PRODUCT_ID)
GROUP BY B.PRODUCT_ID
ORDER BY 3 DESC, 1 ASC