select
    TBL1.ITEM_CODE as CODE,
    ITEM_NAME as NAME,
    sum(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,1 desc
limit 5