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

from ORDERS
inner join ORDERS_DTL
on  ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO 
inner join ITEM
on ORDERS_DTL.ITEM_CODE = ITEM.ITEM_CODE

where date(ORDER_DATE) >= '2023-05-14'
and date(ORDER_DATE) <= '2023-05-20'

group by CODE,NAME

order by TOTAL_AMT desc
        ,CODE desc

limit 5