牛客585057951号
牛客585057951号
全部文章
分类
题解(10)
归档
标签
去牛客网
登录
/
注册
牛客585057951号的博客
全部文章
(共13篇)
题解 | #确定哪些订单购买了 prod_id 为 BR01 的产品(二)#
select cust_id,order_date from OrderItems oi,Orders o where oi.order_num = o.order_num and prod_id = 'BR01' order by order_date
Mysql
2022-05-13
0
162
题解 | #从 Products 表中检索所有的产品名称以及对应的销售总数#
select prod_name,a quant_sold from Products join( select prod_id,sum(quantity) a from OrderItems group by prod_id) b on Products.prod_id = b.prod_id
Mysql
2022-05-13
0
142
题解 | #返回每个顾客不同订单的总金额#
先子查询,得到每个订单的总金额 再与orders表连接,得到每个顾客的不同订单的总金额 select cust_id,sum(a) from Orders join (select order_num,sum(item_price*quantity) as a from Orde...
Mysql
2022-05-13
0
220
首页
上一页
1
2
下一页
末页