阿莉勒丝黛拉

题解

/ 注册

全部文章 / 题解（共162篇）

题解 | #从 Products 表中检索所有的产品名称以及对应的销售总数#

SELECT p.prod_name, tb.quantity FROM ( SELECT &nb...

Mysql

2022-03-07

30 1448

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

SELECT o.cust_id cust_id, tb.total_ordered total_ordered FROM ( ...

Mysql

2022-03-07

60 3646

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

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

Mysql

2022-03-05

47 2680

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

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

Mysql

2022-03-05

2 760

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

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

Mysql

2022-03-05

14 1087

题解 | #纠错3#

SELECT order_num, COUNT(*) items FROM OrderItems GROUP BY &nbs...

Mysql

2022-03-05

2 718

题解 | #计算总和#

SELECT order_num, SUM(item_price * quantity) total_price FROM &...

Mysql

2022-03-05

11 1338

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

SELECT order_num FROM OrderItems GROUP BY order_num HAVING &n...

Mysql

2022-03-05

5 691

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

SELECT vend_id, MIN(prod_price) cheapest_item FROM Products GROUP&n...

Mysql

2022-03-05

22 3117

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

SELECT order_num, COUNT(order_num) order_lines FROM OrderItems GROU...

Mysql

2022-03-05

9 1912