shenggong
shenggong
全部文章
题解
归档
标签
去牛客网
登录
/
注册
shenggong的博客
全部文章
/ 题解
(共35篇)
题解 | #返回顾客名称和相关订单号以及每个订单的总价#
SELECT a.cust_name,b.order_num,SUM(c.quantity*c.item_price) AS OrderTotal FROM Customers a INNER JOIN Orders b ON a.cust_id=b.cust_id INNER JOIN Order...
Mysql
2022-03-24
0
175
题解 | #返回顾客名称和相关订单号#
Solution 1: SELECT a.cust_name,b.order_num FROM Customers a,Orders b WHERE a.cust_id=b.cust_id ORDER BY a.cust_name; Solution 2: SELECT a.cust_name,b....
Mysql
2022-03-12
0
171
题解 | #从 Products 表中检索所有的产品名称以及对应的销售总数#
SELECT a.prod_name,b.quant_sold FROM Products a INNER JOIN (SELECT prod_id,SUM(quantity) AS quant_sold FROM OrderItems GROUP BY prod_id) b ON a.prod_i...
Mysql
2022-03-12
0
139
题解 | #返回每个顾客不同订单的总金额#
SELECT a.cust_id,b.total_ordered FROM Orders a INNER JOIN (SELECT order_num,SUM(item_price*quantity) AS total_ordered FROM OrderItems GROUP BY order_n...
Mysql
2022-03-11
12
661
题解 | #返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件(一)#
SELECT c.cust_email FROM Customers c, (SELECT a.prod_id,a.order_num,b.cust_id FROM OrderItems a INNER JOIN Orders b ON a.order_num=b.order_num WHERE a...
Mysql
2022-03-11
1
425
首页
上一页
1
2
3
4
下一页
末页