with t as (
    select z.item_code as code, unitprice * order_qty as cost, item_name as name
    from orders as x
    join orders_dtl as y
    on y.order_no = x.order_no
    join item as z
    on z.item_code = y.item_code
    where order_date >= "2023-05-14" and order_date <= "2023-05-20"
)
select code as CODE, name as NAME, sum(cost) as TOTAL_AMT
from t
group by code
order by 3 desc, 1 desc
limit 5