Create SQL statements for each operation. Assume the following entities $($tables$)$ exist with their

appropriate column names as described below. You may assume PK and FK columns.

Faculty

Students

Course

Term

a$.$ Select: retrieve faculty members whose rank is professor.

b$.$ Project: list faculty number, first name and last name of all faculty members.

c$.$ Join: show faculty number, first name, last name with the course offering number, course number,

term, and year they teach.

d$.$ Join: list course number and student names for courses offered in spring $2020.$

e$.$ Aggregation: show the total number of faculty.