faculty course database: Department DepartmentID Department Name Faculty FacultyID DepartmentID LastName FirstName Salary Title Email FacultyCourse Faculty Coursel FacultyID Course Number Semester Course Course Number Name Description Here is some information that will help you: . The schema (database) name is FacDB The Department table contains the departments in the school. Each row is a unique department. The Faculty table contains faculty members that work at the school. Each row is a unique faculty member. The Course table contains courses offered by the school. Each row is a unique course. Here, as presented in class, is the general syntax of a SQL statement: . SELECT (DISTINCT) expression(s) FROM schema_name.table_name(s) [WHERE condition(s)] (GROUP BY expression(s)] Anty DepartmentID DepartmentName FacultyID DepartmentID LastName FirstName Salary Title Email FacultyCoursel FacultyID CourseNumber Semester Course Number Name Description How many faculty members in each department has the last name Smith. Show the number. Be sure to include any department that has no faculty member. Display department ID and the number of faculty members. Edit View Insert Format Tools Table 12pt Paragraph BI U AV 2 T2 : I Al....pptx Department DepartmentID DepartmentName Faculty Faculty DepartmentID LastName FirstName Salary Title FacultyCourse FacultyCoursel FacultyID CourseNumber Semester Course Course Number Name Description Email What is the total salary of assistant professors per department (as identified by DepartmentID), arranged from lowest to highest based on total salary? Display department ID and total salary (Hint: Assistant Professor is a job title.) Edit View Insert Format Tools Table 12pt Paragraph AT > Question 18 6 pts How many faculty members have a salary between $50,000 and $80,000? Display the number of faculty members. Edit View Insert Format Tools Table 12pt Paragraph ev Tv I O words > Question 19