Show the first and last name of the student.
select fname, lname from student
For each of them, count the number of activities.
select t1.fname, t1.lname, count(*) from student as t1 join participates_in as t2 on t1.stuid = t2.stuid group by t1.stuid
Sort the names in descending order by the number of activities.
select t1.fname, t1.lname from student as t1 join participates_in as t2 on t1.stuid = t2.stuid group by t1.stuid order by count(*) desc
Who has the most?
select t1.fname, t1.lname from student as t1 join participates_in as t2 on t1.stuid = t2.stuid group by t1.stuid order by count(*) desc limit 1