with DTL_ITEMS as(
select *
from ORDERS_DTL
inner join ITEM
on ORDERS_DTL.ITEM_CODE=ITEM.ITEM_CODE
),
TMP as (
select *
from DTL_ITEMS
inner join ORDERS
on DTL_ITEMS.ORDER_NO = ORDERS.ORDER_NO
where ORDER_DATE between "2023-05-14" and "2023-05-20"
)

select ITEM_CODE as CODE,
ITEM_NAME as NAME, 
sum(UNITPRICE *ORDER_QTY) as TOTAL_AMT
from TMP
group by ITEM_CODE
order by TOTAL_AMT desc
limit 5
;