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