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