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