SELECT od.ITEM_CODE AS CODE,
i.ITEM_NAME AS NAME,
sum(od.ORDER_QTY*od.UNITPRICE) AS TOTAL_AMT

FROM ORDERS AS o

 INNER JOIN ORDERS_DTL AS od
    ON od.ORDER_NO=o.ORDER_NO
 INNER JOIN ITEM AS i
   ON  od.ITEM_CODE=i.ITEM_CODE

WHERE o.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'

GROUP BY od.ITEM_CODE,i.ITEM_CODE




ORDER BY TOTAL_AMT DESC,od.ITEM_CODE DESC

LIMIT 5;