주문량이 많은 아이스크림들 조회하기1 JOIN>주문량이 많은 아이스크림들 조회하기 -- 직접 짠 코드. SELECT C.FLAVOR FROM ( SELECT A.SHIPMENT_ID, A.FLAVOR, SUM(A.TOTAL_ORDER + B.TOTAL_ORDER) AS TOTAL FROM FIRST_HALF A JOIN JULY B ON A.FLAVOR = B.FLAVOR GROUP BY FLAVOR ORDER BY TOTAL DESC ) AS C ORDER BY C.TOTAL DESC LIMIT 3 -- GPT로부터 첨삭받음. SELECT C.FLAVOR FROM ( SELECT A.FLAVOR, SUM(A.TOTAL_ORDER + B.TOTAL_ORDER) AS TOTAL FROM FIRST_HALF A JOIN JULY B ON A.FLAVOR = B.FLAVOR GROUP BY.. 2023. 2. 26. 이전 1 다음 728x90