What are the faculty id and the number of students each faculty has?
select t1.facid, count(*) from faculty as t1 join student as t2 on t1.facid = t2.advisor group by t1.facid