WITH s1 as (
    select
        t1.ITEM_CODE
        ,t1.UNITPRICE
        ,t1.ORDER_QTY
    from 
        ORDERS_DTL t1
            left outer join
        ORDERS t2
            on t1.ORDER_NO = t2.ORDER_NO
    where
        t2.ORDER_DATE between '2023-05-14' and '2023-05-20'
),

s2 as(
    select
        t3.ITEM_CODE
        ,t4.ITEM_NAME
        ,t3.UNITPRICE
        ,t3.ORDER_QTY
    from
        s1 t3
            left outer join
        ITEM t4
            on t3.ITEM_CODE = t4.ITEM_CODE
)

select
    ITEM_CODE as CODE
    ,ITEM_NAME as NAME
    ,SUM(UNITPRICE * ORDER_QTY) as TOTAL_AMT
from
    s2
group by
    ITEM_CODE
    ,ITEM_NAME
order by
    SUM(UNITPRICE * ORDER_QTY) DESC
    ,ITEM_CODE DESC
LIMIT 5