1984 Chem Ap Answers In Dire Need Of Help ... Related To SQL Query (I'm Using Oracle 9i Version)?

In dire need of help ... related to SQL query (I'm using Oracle 9i version)? - 1984 chem ap answers

I have a table with the name: FAKULTÄT
He made the following statement --

FacultyCode: NOT NULL, primary key, starting with "F"
FacultyName: Not null
DateOfJoin: Not null
DeptCode: You need to CSE, IT, CA, CHEM, MTHS, Phys, HUM, BAA

Another image that is created I: SERVICE
It has the following details --

DeptCode: NOT NULL, primary key
Department Name: Not null
JD: The foreign key references FacultyCode School Table

Then I inserted the data in these 2 tables. Now the question is "Name of the departments with the largest number of schools and the names of the faculties. How do you solve this in SQL queries?