select
    TBL1.ITEM_CODE as CODE,
    ITEM_NAME as NAME,
    UNITPRICE * sum(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,
    UNITPRICE
order by
    3 desc,TBL1.ITEM_CODE asc
limit 5