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-15' < ORDER_DATE
	AND ORDER_DATE < '2023-5-21'
GROUP BY
	CODE
ORDER BY
	TOTAL_AMT DESC
	,CODE DESC
LIMIT 5