SELECT
	ITEM.ITEM_CODE AS CODE
,	ITEM.ITEM_NAME AS NAME
,	SUM(ORDERS_DTL.UNITPRICE * ORDERS_DTL.ORDER_QTY) AS TOTAL_AMT
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
limit 5
;