table student id PK name faculty_id table faculty id PK name SELECT f.name FROM faculty f JOIN student s ON s.faculty_id = f.id GROUP BY f.id, f.name ORDER BY COUNT(s.id) DESC LIMIT 1;