题解 | #平均绩点大于3.6且总人数大于2学生情况#

select university,count(1) total_cnt,sum(if(gender='male',1,0)) male_cnt ,
       sum(if(gender='female',1,0)) female_cnt,sum(if(age<23,1,0)) lt23_cnt
from user_profile
group by university
having avg(gpa)>3.6 and count(university)>2