with o as (
    select ORDER_NO from ORDERS
    where ORDER_DATE between '2023-05-14' and '2023-05-20'
),
i as (
    select UNITPRICE, ORDER_QTY, ITEM_CODE, ITEM_NAME
    from ORDERS_DTL join ITEM on ITEM_CODE
    where ORDER_NO in o
)
select * from i;