Show the first and last name of the faculty.
select fname, lname from faculty
For each faculty member, also count the number of students advised.
select t1.fname, t1.lname, count(*) from faculty as t1 join student as t2 on t1.facid = t2.advisor group by t1.facid
Show the names in descending order of the number.
select t1.fname, t1.lname from faculty as t1 join student as t2 on t1.facid = t2.advisor group by t1.facid order by count(*) desc
Who has the most?
select t1.fname, t1.lname from faculty as t1 join student as t2 on t1.facid = t2.advisor group by t1.facid order by count(*) desc limit 1