select 
ORDERS_DTL.ITEM_CODE as CODE
, ITEM.ITEM_NAME as NAME
, SUM(ORDERS_DTL.UNITPRICE * ORDERS_DTL.ORDER_QTY) as TOTAL_AMT
from ORDERS JOIN ORDERS_DTL on ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO
join ITEM on ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE
where ORDERS.ORDER_DATE between '2023-05-14' and '2023-05-20'
group by ORDERS_DTL.ITEM_CODE
order by TOTAL_AMT desc
limit 5