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