牛客257734998号

分类

题解(13)

/ 注册

全部文章（共13篇）

题解 | #插入记录（三）#

replace into examination_info (exam_id,tag,difficulty,duration,release_time) values (9003,'SQL','hard',90,'2021-01-01 00:00:00 ') //replace into 和 ins...

Mysql

2022-04-11

0 287

题解 | #插入记录（二）#

insert into exam_record_before_2021(uid,exam_id,start_time,submit_time,score) select uid,exam_id,start_time,submit_time,score from exam_record where ...

Mysql

2022-04-11

0 239

题解 | #插入记录（一）#

insert into exam_record (uid,exam_id,start_time,submit_time,score ) values (1001,9001,'2021-09-01 22:11:12','2021-09-01 23:01:12','90'), (1002,9002,'2...

Mysql

2022-04-11

0 240

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

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

Mysql

2022-04-11

0 284

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

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

Mysql

2022-04-11

0 259

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

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

Mysql

2022-04-11

0 287

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

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

Mysql

2022-04-08

0 236

题解 | #找出每个学校GPA最低的同学#

select a.device_id,a.university,a.gpa from (select device_id,university,gpa, rank()over(partition by university order by gpa) as rank1 // 为什么不能将列名称命名为...

Mysql

2022-04-01

0 305

题解 | #查找GPA最高值#

max(gpa) as max_gpa // max(字段or列名称）as 新的字段名称 from user_profile where university = '复旦大学'

Mysql

2022-03-29

0 197

题解 | #查找某个年龄段的用户信息#

device_id, gender, age from user_profile where age >= 20 and age <= 23 // 取20<=a<=23的时候，用 and 连接前后条件，要写在同一行内，不能分开隔行

Mysql

2022-03-29

0 238