with
    A as (
        select
            ORDER_NO,
            ITEM_CODE,
            ITEM_NAME,
            UNITPRICE,
            ORDER_QTY
        from
            ORDERS_DTL join ITEM using(ITEM_CODE)
    )

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