select ORD_D.ITEM_CODE as CODE
     , ITM.ITEM_NAME as NAME
     , SUM(CAST(ORD_D.UNITPRICE * ORD_D.ORDER_QTY as real)) as TOTAL_AMT
from ORDERS_DTL as ORD_D
inner join ORDERS as ORD
        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'
group by ORD_D.ITEM_CODE, ITM.ITEM_NAME
order by 3 desc, 1 desc
limit 5