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