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