table student id PK name faculty_id table faculty id PK name SELECT f.name, count(*) FROM faculty f JOIN student s ON s.faculty_id = f.id GROUP BY f.id, f.name GROUP BY /*f.id,*/ f.name GROUP BY f.id/*, f.name*/