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