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