[SQL문제풀기] 5월 식품들의 총매출 조회하기

silver

Dec 23, 2024

Contents

MYSQL ORECLE

문제

school.programmers.co.kr

https://school.programmers.co.kr/learn/courses/30/lessons/131117

MYSQL

내가 작성한 오답

→ 오답의 이유

한개의 product_id에 여러 주문이 존재한다는 생각을 하지 못했다.

내가 작성한 정답


SELECT P.PRODUCT_ID, P.PRODUCT_NAME, SUM(P.PRICE*O.AMOUNT) AS TOTAL_SALES
FROM FOOD_PRODUCT P
JOIN FOOD_ORDER O ON P.PRODUCT_ID = O.PRODUCT_ID
WHERE DATE_FORMAT(O.PRODUCE_DATE,'%y%m') = '2205'
GROUP BY P.PRODUCT_ID,P.PRODUCT_NAME
ORDER BY TOTAL_SALES DESC, P.PRODUCT_ID ASC;

ORECLE

내가 작성한 정답


SELECT P.PRODUCT_ID, P.PRODUCT_NAME, SUM(P.PRICE*O.AMOUNT) AS TOTAL_SALES
FROM FOOD_PRODUCT P
JOIN FOOD_ORDER O ON P.PRODUCT_ID = O.PRODUCT_ID
WHERE TO_CHAR(O.PRODUCE_DATE,'YYMM') = '2205'
GROUP BY P.PRODUCT_ID,P.PRODUCT_NAME
ORDER BY TOTAL_SALES DESC, P.PRODUCT_ID ASC;

SQL문제풀기

[SQL문제풀기] 5월 식품들의 총매출 조회하기

silver

Dec 23, 2024

Contents

MYSQL ORECLE

문제

school.programmers.co.kr

https://school.programmers.co.kr/learn/courses/30/lessons/131117

MYSQL

내가 작성한 오답

→ 오답의 이유

한개의 product_id에 여러 주문이 존재한다는 생각을 하지 못했다.

내가 작성한 정답


SELECT P.PRODUCT_ID, P.PRODUCT_NAME, SUM(P.PRICE*O.AMOUNT) AS TOTAL_SALES
FROM FOOD_PRODUCT P
JOIN FOOD_ORDER O ON P.PRODUCT_ID = O.PRODUCT_ID
WHERE DATE_FORMAT(O.PRODUCE_DATE,'%y%m') = '2205'
GROUP BY P.PRODUCT_ID,P.PRODUCT_NAME
ORDER BY TOTAL_SALES DESC, P.PRODUCT_ID ASC;

ORECLE

내가 작성한 정답


SELECT P.PRODUCT_ID, P.PRODUCT_NAME, SUM(P.PRICE*O.AMOUNT) AS TOTAL_SALES
FROM FOOD_PRODUCT P
JOIN FOOD_ORDER O ON P.PRODUCT_ID = O.PRODUCT_ID
WHERE TO_CHAR(O.PRODUCE_DATE,'YYMM') = '2205'
GROUP BY P.PRODUCT_ID,P.PRODUCT_NAME
ORDER BY TOTAL_SALES DESC, P.PRODUCT_ID ASC;