垫底菜鸡

分类

/ 注册

全部文章（共53篇）

题解 | #返回购买有顾客的电子邮件（二）#

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

2023-03-05

0 268

组合 Products 表中的产品名称

select prod_name from Products union select cust_name from Customers order by prod_name asc 用union组合

2023-03-05

0 238

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

select cust_name, sum(item_price*quantity) as total_price from Customers as c inner join Orders on c.cust_id = Orders.cust_id inner join OrderItems o...

2023-03-05

0 292

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

select c.cust_name,o.order_num, sum(oi.quantity*oi.item_price) as OrderTotal from Customers as c inner join Orders as o on c.cust_id = o.cust_id inne...

2023-03-05

0 268

题解 | #对顾客ID和日期排序#

select cust_id,order_num from Orders order by cust_id asc,order_date desc easy

2023-03-04

0 240

题解 | #检索顾客名称并且排序#

select cust_name from Customers order by cust_name desc 升降序

2023-03-04

0 229

题解 | #检索并列出已订购产品的清单#

select distinct prod_id from OrderItems easy

2023-03-04

0 240

题解 | #从 Customers 表中检索所有的 ID#

select * from Customers easy

2023-03-04

0 230

题解 | #21年8月份练题总数#

select count(distinct device_id) as did_cnt, count(question_id) as question_cut from question_practice_detail where date like '2021-08%' g...

2023-03-04

0 300

题解 | #查找后降序排列#

select device_id,gpa,age from user_profile order by gpa desc, age desc 和上一道题思路一样

2023-03-04

0 191