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