SELECT  DTL.ITEM_CODE AS CODE 
       ,IT.ITEM_NAME AS NAME
       ,SUM(DTL.UNITPRICE * DTL.ORDER_QTY) AS TOTAL_AMT
  FROM ORDERS OD
INNER JOIN ORDERS_DTL AS DTL
    ON OD.ORDER_NO = DTL.ORDER_NO
INNER JOIN ITEM  IT
    ON DTL.ITEM_CODE = IT.ITEM_CODE
WHERE OD.ORDER_DATE BETWEEN '2023-05-14' AND '2023-05-20'
GROUP BY DTL.ITEM_CODE,IT.ITEM_NAME
ORDER BY 3 desc,1 desc