select a.university, count(a.device_id) as total_cnt, sum(if(a.gender='male',1 ,0)) as male_cnt, sum(if(a.gender='female',1 ,0)) as female_cnt, sum(if(a.age<23,1,0)) as lt23_cnt from( select device_id, gender, age, university, avg(g...