#平均绩点大于3.6且总人数大于2的学校里学生情况#
平均绩点大于3.6且总人数大于2的学校里学生情况
https://www.nowcoder.com/practice/5efb7d06f3e944ec81c40193b22c4b5f
select university ,count(device_id) total_cnt ,count(case when gender='male' then 1 else null end) male_cnt ,count(case when gender='female' then 1 else null end) female_cnt ,count(case when age<23 then device_id else null end) lt23_cnt from user_profile group by university having avg(gpa)>3.6 and count(device_id)>2;
投递荣耀等公司10个岗位