with s as (select 
orders_dtl.ITEM_CODE,
SUM(UNITPRICE * ORDER_QTY) as TOTAL_AMT
from orders join orders_dtl on orders.ORDER_NO = orders_dtl.ORDER_NO
where order_date between '2023-05-14' and '2023-05-20'
group by ITEM_CODE
)
select 
s.ITEM_CODE as CODE
, item.ITEM_NAME as NAME
, s.TOTAL_AMT as TOTAL_AMT
from s join item on s.ITEM_CODE = item.ITEM_CODE
order by TOTAL_AMT desc, CODE desc
limit 5