select
d.ITEM_CODE as CODE,
i.ITEM_NAME as NAME,
(d.UNITPRICE*d.ORDER_QTY) as TOTAL_AMT
from
ORDERS AS o
left join ORDERS_DTL AS d on o.ORDER_NO = d.ORDER_NO
left join ITEM AS i on d.ITEM_CODE = i.ITEM_CODE 
where
'2023-05-20' >= ORDER_DATE AND ORDER_DATE >= '2023-05-14'