SELECT      o.cust_id cust_id,     o.order_date order_date FROM OrderItems oi INNER JOIN Orders o ON     (oi.prod_id = 'BR01') AND     (oi.order_num =...

SELECT      c.cust_name cust_name,     o.order_num order_num,     SUM(oi.quantity * oi.item_price) OrderTotal FROM Customers c INNER JOIN Orders o ON     c...

SELECT      cust_name,     order_num FROM     Customers c INNER JOIN Orders o ON     c.cust_id = o.cust_id ORDER BY     cust_name,    &...

加油！

SELECT      p.prod_name,     tb.quantity FROM (     SELECT         prod_id,         SUM(quantity) quantity     FROM  &nb...

SELECT      o.cust_id cust_id,     tb.total_ordered total_ordered FROM (     SELECT         order_num,         SUM(item_price * qu...

加油！

SELECT      cust_email FROM     Customers WHERE     cust_id IN (         SELECT              cust_id    &...

SELECT   cust_id,   order_date FROM   Orders WHERE   order_num IN (     SELECT       order_num     FROM       OrderItems     WHERE       prod_id = 'BR01'   ) ORDER BY   order_date;

加油！

SELECT      cust_id FROM     Orders WHERE     order_num IN (         SELECT             order_num     &nb...

SELECT      order_num,     COUNT(*) items FROM     OrderItems GROUP BY     order_num HAVING     items >= 3 ORDER BY     items,    &n...

SELECT      order_num,     SUM(item_price * quantity) total_price FROM     OrderItems GROUP BY     order_num HAVING     total_price >= 1000 ORDER BY  &n...

SELECT      order_num FROM     OrderItems GROUP BY     order_num HAVING     SUM(quantity) >= 100 ORDER BY     order_num;