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