select
    TBL1.ITEM_CODE as CODE,
    ITEM_NAME as NAME,
    sum(TOTAL_AMT)
from
    (
    select 
        ORDER_NO,
        ITEM_CODE,
        UNITPRICE * ORDER_QTY as TOTAL_AMT
    from
        ORDERS_DTL
    ) as TBL1
left outer join
    ORDERS as TBL2 on TBL1.ORDER_NO = TBL2.ORDER_NO
left outer join
    ITEM as TBL3 on TBL1.ITEM_CODE = TBL3.ITEM_CODE
where
    TBL2.ORDER_DATE >= '2023-05-14'
    and '2023-05-20' >= TBL2.ORDER_DATE
group by
    TBL1.ITEM_CODE,ITEM_NAME
order by
    3 desc,TBL1.ITEM_CODE asc
limit 5