SELECT MAX(I.ITEM_CODE) AS CODE, MAX(I.ITEM_NAME) AS NAME,SUM(UNITPRICE*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-5-14 AND ORDER_DATE<=2023-5-20