What are the full names of all the faculty?
select fname, lname from faculty
Order them by the number of courses they teach, descending.
select t2.fname, t2.lname from course as t1 join faculty as t2 on t1.instructor = t2.facid group by t1.instructor order by count(*) desc
Who are the top three?
select t2.fname, t2.lname from course as t1 join faculty as t2 on t1.instructor = t2.facid group by t1.instructor order by count(*) desc limit 3