select
    od.ITEM_CODE as CODE,
    i.ITEM_NAME as NAME,
    sum(od.UNITPRICE * od.ORDER_QTY) as TOTAL_AMT
from
    ORDERS_DTL as od
join
    ORDERS as o on o.ORDER_NO = od.ORDER_NO
join
    ITEM as i on  i.ITEM_CODE = od.ITEM_CODE
where
    o.ORDER_DATE between date("2023-05-14") and date("2023-05-20")
group by
    NAME,CODE
order by
    TOTAL_AMT desc,
    CODE desc