I've been having some issues with this homework, I've got a couple of them down but nothing I feel confident about. We've been using the SQL online Query in db-book.com

Problem 1. From the instructor relation of the large university database, find the number of professors in each of the department of the university. Problem 2. From the student, advisor and instructor relations of the small university database, find the name of the students and their corresponding advisor's name. Problem 3. From the classroom relation of the large university database, create a view of the buildings and total capacity (sum of the capacity of each room in that building) of each building. Problem 4. From the course and prerequisite relations of the small university database create a view of the course_id, title, dept_name, credits and prereq_id. In your view all the courses should be present even if it does not require any prerequisite (prereq_id attribute value should be null for those courses). Problem 5. From the instructor and department relations of the small university database, find the names of all the instructors whose department is not located in the Watson building. Submission guideline: For each of the problems submit the SQL query and the output relation. Submit your solution in blackboard as a word or pdf file. Hardcopy submission will not be accepted