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