题解 | #平均绩点大于3.6且人数大于2的学校里学生情况#
平均绩点大于3.6且总人数大于2的学校里学生情况
https://www.nowcoder.com/practice/5efb7d06f3e944ec81c40193b22c4b5f
select university ,
count(*) as total_cnt,
count(gender='male' or null) as male_cnt,
count(gender='female' or null) as female_cnt,
count(age<23 or null) as lt23_cnt
from user_profile
group by university
having avg(gpa)>3.6 and total_cnt>2;
查看8道真题和解析
