select 
item.ITEM_CODE as CODE,
item.ITEM_NAME as NAME,
sum(ORDERS_DTL.UNITPRICE * ORDERS_DTL.ORDER_QTY) as TOTAL_AMT


from item
inner join ORDERS_DTL
on item.item_code = ORDERS_DTL.item_code

inner join ORDERS
on ORDERS_DTL.ORDER_NO = ORDERS.ORDER_NO

where 
ORDERS.ORDER_DATE >= '2023-05-14' 
and
ORDERS.ORDER_DATE <= '2023-05-20'

group by item.item_code

order by TOTAL_AMT desc, item.item_code desc

limit 5
;