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