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