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