求offer.

分类

题解(8)

/ 注册

全部文章（共4篇）

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

select device_id,gpa,age from user_profile order by gpa desc ,age desc;

Mysql

2022-04-14

1 202

题解 | #计算男生人数以及平均GPA#

select count(gender) as male_num,round(avg(gpa),1) as avg_gpa from user_profile where gender = 'male';

Mysql

2022-04-14

0 125

题解 | 操作符混合运用

select device_id,gender,age,university,gpa from user_profile where gpa > 3.5 and university = '山东大学'&a...

Mysql

2022-04-14

0 136

题解 | #Where in 和Not in#

select device_id,gender,age,university,gpa from user_profile where university in ('北京大学','复旦大学','山东大学');

Mysql

2022-04-14

0 122