with A as (
    select
        ITEM_CODE,
        ORDERS.ORDER_DATE,
        UNITPRICE * ORDER_QTY as TOTAL_AMT
    from ORDERS_DTL
        join ORDERS on ORDERS.ORDER_NO = ORDERS_DTL.ORDER_NO
    where
        ORDERS.ORDER_DATE >= '2023-05-15'
        and
        ORDERS.ORDER_DATE <= '2023-05-20'
) select
    A.ITEM_CODE      as CODE,
    ITEM.ITEM_NAME   as NAME,
    sum(A.TOTAL_AMT) as TOTAL_AMT
FROM A
    left join ITEM on ITEM.ITEM_CODE = A.ITEM_CODE
    group by A.ITEM_CODE
    order by TOTAL_AMT desc,
        CODE desc
    LIMIT 5
;