What is all the information about all the faculty?
select * from faculty
Order this by the number of courses each faculty teaches, descending.
select * from course as t1 join faculty as t2 on t1.instructor = t2.facid group by t1.instructor order by count(*) desc
What is the building that the one who teachest the most lives in?
select t2.building from course as t1 join faculty as t2 on t1.instructor = t2.facid group by t1.instructor order by count(*) desc limit 1