题解 | #平均绩点大于3.6且总人数大于2的学校里学生#
平均绩点大于3.6且总人数大于2的学校里学生情况
https://www.nowcoder.com/practice/5efb7d06f3e944ec81c40193b22c4b5f
select
university,count(device_id) total_cnt,
sum(if(gender='male',1,0))male_cnt,
sum(if(gender='female',1,0))female_cnt,
sum(if(age<23,1,0)) lt23_cnt
from user_profile
group by university
having avg(gpa)>3.6 and count(device_id)>2;
university,count(device_id) total_cnt,
sum(if(gender='male',1,0))male_cnt,
sum(if(gender='female',1,0))female_cnt,
sum(if(age<23,1,0)) lt23_cnt
from user_profile
group by university
having avg(gpa)>3.6 and count(device_id)>2;
，校友加油
