题解 | #确定哪些订单购买了 prod_id 为 BR01 的产品（二）#
确定哪些订单购买了 prod_id 为 BR01 的产品（二）
http://www.nowcoder.com/practice/999aa31a9a504c60baa088d90d82e64d
with t1 as (
select order_num
from OrderItems
where prod_id="BR01"
)
select cust_id,order_date
from t1 inner join Orders
on t1.order_num=Orders.order_num
order by order_date
select order_num
from OrderItems
where prod_id="BR01"
)
select cust_id,order_date
from t1 inner join Orders
on t1.order_num=Orders.order_num
order by order_date
