select
    ITEM_CODE as CODE
    ,ITEM_NAME as NAME
    ,sum(UNITPRICE*ORDER_QTY) as TOTAL_AMT
from
    ORDERS
join
    ORDERS_DTL 
    using(ORDER_NO)
join
    ITEM
    using(ITEM_CODE)
where
    date(ORDER_DATE) between '2023-05-14' and '2023-05-20'
group by
    1,2
order by
    TOTAL_AMT desc
    ,CODE desc
limit 5