题解 | #确定订单#

SELECT
    t2.cust_id,
    t2.order_date
FROM
    OrderItems t1,
    Orders t2
where
    t1.order_num = t2.order_num and t1.prod_id = "BR01"
group by
    t2.cust_id,
    t2.order_date
order by
    t2.order_date asc

#编写 SQL 语句，使用子查询来确定哪些订单（在 OrderItems 中）购买了 prod_id 为 "BR01" 的产品，然后从 Orders 表中返回每个产品对应的顾客 ID（cust_id）和订单日期（order_date），按订购日期对结果进行升序排序