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