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