with a as (
    select *
    from ORDERS
    where ORDER_DATE>='2023-05-14'
    and ORDER_DATE < '2023-05-21'
)
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
left join
    ITEM as c
    on b.ITEM_CODE = c.ITEM_CODE
group by b.ITEM_CODE
order by TOTAL_AMT desc
    ,CODE
limit 5