SELECT
I.ITEM_CODE AS CODE
,I.ITEM_NAME AS NAME
,SUM(OD.UNITPRICE*OD.ORDER_QTY) AS TOTAL_AMT
FROM ITEM I
INNER JOIN
ORDERS_DTL OD
 ON I.ITEM_CODE = OD.ITEM_CODE
INNER JOIN
ORDERS O
 ON OD.ORDER_NO = O.ORDER_NO
GROUP BY CODE

HAVING
O.ORDER_DATE > '2023-05-13'
AND
O.ORDER_DATE < '2023-05-21'


ORDER BY
TOTAL_AMT DESC
,CODE DESC



LIMIT 5;