Write the questions in sql format

Professor(Id, Name, DeptId)

Course(CrsCode, DeptId, CrsName, Description)

Teaching(ProfId, CrsCode, Semester)

Note: Values for Semester are YYYY (F | S | W), e.g., 2018F', 2019W Questions:

Find the names of all professors who taught in Fall 2018

Find the names of all courses taught in Fall 2018, together with the names of professors who taught them

Find the average number of courses taught by professors in Comp. Sc. (CS)

Find the number of courses taught by each professor in Comp. Sc. (CS)

Find the number of courses taught by each professor in Comp. Sc. (CS) in 2018