select ORD_D.ITEM_CODE as CODE
     , ITM.ITEM_NAME as NAME
     , CAST(ORD_D.UNITPRICE * ORD_D.ORDER_QTY as real) as TOTAL_AMT
from ORDERS as ORD
inner join ORDERS_DTL as ORD_D
        on ORD.ORDER_NO = ORD_D.ORDER_NO
inner join ITEM as ITM
        on ORD_D.ITEM_CODE = ITM.ITEM_CODE
where ORD.ORDER_DATE between '2023-05-14' and '2023-05-20'
order by 3 desc, 1 desc
limit 5