Alina_0229

题解

/ 注册

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

题解 | #检索每个顾客的名称和所有的订单号（一）#

select Customers.cust_name,Orders.order_num from Customers inner join Orders on Customers.cust_id = Orders.cust_id order by Customers.cust_name asc

Mysql

2022-03-10

0 245

题解 | #确定最佳顾客的另一种方式（二）#

select Customers.cust_name, sum(OrderItems.item_price * OrderItems.quantity) total_price from OrderItems join Orders on OrderItems.order_num = Orders....

Mysql

2022-03-10

0 242

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

select Customers.cust_email from OrderItems join Orders on OrderItems.order_num = Orders.order_num join Customers on Orders.cust_id = Customers.cust_i...

Mysql

2022-03-10

0 228

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

select Orders.cust_id,Orders.order_date from OrderItems,Orders where OrderItems.order_num = Orders.order_num and OrderItems.prod_id="BR01" order by Or...

Mysql

2022-03-10

0 248

题解 | #返回顾客名称和相关订单号以及每个订单的总价#

select C.cust_name,O.order_num,sum(OI.quantity * OI.item_price) OrderTotal from Customers C join Orders O on C.cust_id =O.cust_id join OrderItems OI o...

Mysql

2022-03-10

0 290

题解 | #返回顾客名称和相关订单号以及每个订单的总价#

select C.cust_name,O.order_num,sum(OI.quantity * OI.item_price) OrderTotal from Customers C join Orders O on C.cust_id =O.cust_id join OrderItems OI o...

Mysql

2022-03-10

1 310

题解 | #返回顾客名称和相关订单号#

select Customers.cust_name,Orders.order_num from Customers,Orders where Customers.cust_id=Orders.cust_id order by Customers.cust_name asc,Orders.order...

Mysql

2022-03-10

0 249

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

select p.prod_name,sum(o.quantity) quant_sold from Products p,OrderItems o where p.prod_id = o.prod_id group by prod_name 将两表进行关联，从关联表中进行查询，最后再分组，依据产品...

Mysql

2022-03-10

2 365

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

三层子查询,先从最里层写，查询到prod_id ="BR01"的订单编号 select order_num from OrderItems where prod_id ="BR01" 查询到prod_id ="BR01"的客户id select cust_id from Orders where o...

Mysql

2022-03-08

0 282

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

获取到prod_id="BR01"的订单号 select order_num from OrderItems where prod_id="BR01" 把需要获取的内容写在外层，将订单编号的条件进行子查询 select cust_id,order_date from Orders where ord...

Mysql

2022-03-08

0 323