Objective $2$: Show which student is enrolled in which courses. Display each student$$s student

number, first name, last name, course number, and course title.

hint: SELECT...FROM...WHERE...

Objective $3$: Show the number of offerings that each faculty member has.

hint: SELECT $\_\_\_\_\_,\_\_\_\_\_,\_\_\_\_\_,$ COUNT $($distinct $\_\_\_\_)$ as #$\_$of$\_$offerings

FROM $\_\_\_\_\_\_\_\_,\_\_\_\_\_\_\_$

WHERE $\_\_\_\_\_\_\_\_=\_\_\_\_\_\_\_$

GROUP BY $\_\_\_\_\_,\_\_\_\_\_,\_\_\_\_$