可爱的安哥拉兔不讲武德

分类

/ 注册

全部文章（共60篇）

题解 | #查找后排序#

select device_id,age from user_profile order by age asc;

2024-11-08

0 41

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

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

2024-11-07

0 30

题解 | #查找GPA最高值#

select gpa from user_profile where university="复旦大学" order by gpa desc limit 1;

2024-11-07

0 28

题解 | #查看学校名称中含北京的用户#

select device_id,age,university from user_profile where university like "%北京%";

2024-11-07

0 44

题解 | #操作符混合运用#

select device_id,gender,age,university,gpa from user_profile where university="山东大学" and gpa>3.5 or university="复旦大学" and gpa&g...

2024-11-07

0 39

题解 | #Where in 和Not in#

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

2024-11-07

0 41

题解 | #高级操作符练习(2）#

select device_id,gender,age,university,gpa from user_profile where university = "北京大学" or gpa>3.7;

2024-11-07

0 26

题解 | #高级操作符练习(1)#

select device_id,gender,age,university,gpa from user_profile where gender="male" and gpa>3.5;

2024-11-07

0 37

题解 | #用where过滤空值练习#

select device_id,gender,age,university from user_profile where age is not null;

2024-11-07

0 33

题解 | #查找除复旦大学的用户信息#

select device_id,gender,age,university from user_profile where university != "复旦大学";

2024-11-07

0 36