WITH KINGAKU AS(
SELECT
b.ITEM_CODE
,SUM((b.UNITPRICE * b.ORDER_QTY)) as TOTAL_AMT
FROM
ORDERS a
INNER JOIN ORDERS_DTL b
ON a.ORDER_NO = b.ORDER_NO
WHERE
a.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
GROUP BY
b.ITEM_CODE
)
SELECT
a.ITEM_CODE AS CODE
,a.ITEM_NAME AS NAME
,SUM(b.TOTAL_AMT)
FROM
ITEM a
INNER JOIN KINGAKU b 
ON a.ITEM_CODE = b.ITEM_CODE
GROUP BY
a.ITEM_CODE 
,a.ITEM_NAME
ORDER BY
TOTAL_AMT DESC
,CODE DESC
LIMIT 5
;