GB279824

分类

/ 注册

全部文章（共190篇）

题解 | 返回每个顾客不同订单的总金额

select cust_id, (select sum(quantity * item_price) from OrderItems OI where OI.order_num = Orders.order_num) as total_ordered from Orders ...

2025-05-20

0 30

题解 | 返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（一）

select cust_email from Customers where cust_id in ( select cust_id from Orders where order_num in ( select order_num from ...

2025-05-20

0 42

题解 | 确定哪些订单购买了 prod_id 为 BR01 的产品（一）

select cust_id,order_date from Orders where order_num in( select order_num from OrderItems where prod_id = 'BR01' ) order by order_dat...

2025-05-20

0 43

题解 | 返回购买价格为 10 美元或以上产品的顾客列表

select cust_id from Orders where order_num in( select order_num from OrderItems where item_price >= 10 );

2025-05-20

0 37

题解 | 计算总和

select order_num, sum(quantity * item_price) as total_price from OrderItems group by order_num having total_price >= 1000 order by order_nu...

2025-05-20

0 33

题解 | 返回订单数量总和不小于100的所有订单的订单号

select order_num from OrderItems group by order_num having sum(quantity) >= 100 order by order_num ASC;

2025-05-20

0 36

题解 | 每个供应商成本最低的产品

select vend_id, min(prod_price) as cheapest_item from Products group by vend_id order by cheapest_item ASC;

2025-05-20

0 37

题解 | 返回每个订单号各有多少行数

select order_num, count(order_num) as order_lines from OrderItems group by order_num order by order_lines ASC;

2025-05-20

0 31

题解 | 确定 Products 表中价格不超过 10 美元的最贵产品的价格

select max(prod_price) as max_price from Products where prod_price <= 10;

2025-05-20

0 39

题解 | 确定已售出产品项 BR01 的总数

select sum(quantity) as items_ordered from OrderItems where prod_id = 'BR01';

2025-05-20

0 22