Show the faculty id of each faculty member, along with the number of students he or she advises.
select t1.facid, count ( * ) from faculty as t1 join student as t2 on t1.facid = t2.advisor group by t1.facid
How may faculties in this survey?
select count ( * ) from faculty
Yes.
select count ( * ) from faculty where sex = 'M'