题解 | #哪些订单购买了 prod_id 为 BR01 #
确定哪些订单购买了 prod_id 为 BR01 的产品（一）
https://www.nowcoder.com/practice/b692b0174c0444fa9452aee2d082fbbb
select
Orders.cust_id,
order_date
from
OrderItems,
Orders
where
OrderItems.order_num = Orders.order_num
and OrderItems.prod_id = 'BR01'
order by
order_date
投递XMind等公司10个岗位 >
查看4道真题和解析
