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,
    SUM(UNITPRICE * ORDER_QTY) as TOTAL_AMT
from 
    ORDERS join A using(ORDER_NO)
where
    '2023-5-14' <= date(ORDER_DATE) <= '2023-5-20'
group by
    ITEM_CODE
order by
    TOTAL_AMT desc,
    ITEM_CODE desc
limit
    5
;