Consider the following relational schema:

Student $($snum$,$ fname, sname, major, level, age$)$

Class $($cid cname meets, at room, fid$)$

Enrolled $($snum$,$ cid$)$

Faculty $($fid$,$ fname sname, deptname$)$

Primary keys are underlined, and foreign keys are highlighted in red. Write SQL queries to answer the following:

$($a$)$ Write SQL to create Student, Class, Faculty, and Enrolled tables from the relational schema provided above. Select appropriate data types for each attribute. Also remember to set primary and foreign keys.

$($b$)$ Find fname sname, and major of all students who are seniors level $=3).$

$($c$)$ List the detail of faculty members who taught only in room W$202.$

$($d$)$ For each level, print the level and total number of students belong to that level.