SELECT MAX(I.ITEM_CODE) AS CODE, MAX(I.ITEM_NAME) AS NAME,SUM(OD.UNITPRICE*OD.ORDER_QTY)AS TOTAL_AMT
FROM ITEM AS 'I'
INNER JOIN ORDERS_DTL AS 'OD'
ON I.ITEM_CODE = OD.ITEM_CODE
INNER JOIN ORDERS AS 'O'
ON OD.ORDER_NO =O.ORDER_NO
GROUP BY I.ITEM_CODE
HAVING ORDER_DATE>='2023-05-14' AND ORDER_DATE<='2023-05-20'
ORDER BY TOTAL_AMT DESC,CODE DESC
limit 5;