What is the most common college id?
select college_id from member group by college_id order by count ( * ) desc limit 1
Who went there?
select name from member where college_id = 4
What about the most common country?
select country from member group by country order by count ( * ) desc limit 1