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