CREATE TABLE Student (advisor VARCHAR2)
CREATE TABLE Faculty (FacID VARCHAR2)

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
SELECT "T1"."FacID", COUNT(*) FROM "Faculty" "T1" JOIN "Student" "T2" ON "T1"."FacID" = "T2"."advisor" GROUP BY "T1"."FacID"