SELECT
      OD.ITEM_CODE AS CODE
    , IT.ITEM_NAME AS NAME
    , sum(UNITPRICE * ORDER_QTY) as TOTAL_AMT
FROM
    ORDERS_DTL AS OD 
    INNER JOIN ORDERS  
        ON OD.ORDER_NO = ORDERS.ORDER_NO 
    INNER JOIN ITEM AS IT 
        ON IT.ITEM_CODE  = OD.ITEM_CODE  
WHERE
    DATE(ORDERS.ORDER_DATE) BETWEEN "2023-05-14" AND "2023-05-20"
GROUP BY
    OD.ITEM_CODE 
ORDER BY
    TOTAL_AMT desc,
    OD.ITEM_CODE desc
    
;