shenggong
shenggong
全部文章
分类
题解(49)
归档
标签
去牛客网
登录
/
注册
shenggong的博客
全部文章
(共48篇)
题解 | #返回产品名称和每一项产品的总订单数#
SELECT a.prod_name,COUNT(b.order_num) AS orders FROM Products a LEFT JOIN OrderItems b ON a.prod_id=b.prod_id GROUP BY a.prod_name ORDER BY a.prod_nam...
Mysql
2022-03-26
0
189
题解 | #确定最佳顾客的另一种方式(二)#
SELECT c.cust_name,SUM(a.item_price*a.quantity) AS total_price FROM OrderItems a INNER JOIN Orders b ON a.order_num = b.order_num INNER JOIN Customer...
Mysql
2022-03-25
0
226
题解 | #返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件(二)#
SELECT c.cust_email FROM OrderItems a INNER JOIN Orders b ON a.order_num = b.order_num INNER JOIN Customers c ON b.cust_id=c.cust_id WHERE a.prod_id =...
Mysql
2022-03-24
0
156
题解 | #返回顾客名称和相关订单号以及每个订单的总价#
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
172
题解 | #返回顾客名称和相关订单号#
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
168
题解 | #从 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
136
题解 | #返回每个顾客不同订单的总金额#
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
638
题解 | #返回购买 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
421
首页
上一页
1
2
3
4
5
下一页
末页