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