Lab2_Q1. Find the titles of courses in the Comp. Sci. department that has 3 credits.

Lab2_Q2. Find the IDs of all students taught by an instructor whose name begins with A while you ensure there are no duplicates in the result.

Lab2_Q3. Find the highest salary of any instructor.

Lab2_Q4. Find all instructors earning the highest salary while there could be more than one with the same salary.

Lab2_Q5. Find the enrollment of each section that was offered during Spring 2021.

Lab2_Q6. Find the maximum enrollment, across all sections, during Spring 2021 and Fall 2020 or Fall 2021.

Lab2_Q7. Find the sections that bare the maximum enrollment during Spring 2021.

Lab2_Q8. Print the names of members who borrowed any book published by McGraw-Hill.

Lab2_Q9. Print the names of members who have borrowed all books published by McGrawHill.

Lab2_Q10. For each publisher, print the names of members who have borrowed > 5 books from that publisher.

Lab2_Q11. Print the average count of books borrowed per member while taking into consideration that if a member does not borrow any books, then s/he does not appear in the borrowed relation/table.

Lab2_Q12. Define a view tot credits (year, num credits), giving the total number of credits taken by students in each year.

I am using SQL developer for this

Tables (Filtered) ADVISOR I_ID CLASSROOM BUILDING ROOM_NUMBER CAPACITY COURSE COURSE_ID TITLE DEPT_NAME CREDITS DEPARTMENT DEPT_NAME BUILDING BUDGET INSTRUCTOR ID NAME DEPT_NAME SALARY ORDERS DEPT_NAME SALARY ORDERS PERSON_ID FIRST_NAME LAST_NAME PREQ COURSE_ID PREREQ_ID SECTION COURSE_ID SEC_ID SEMESTER YEAR BUILDING ROOM_NUMBER TIME_SLOT_ID STUDENT ID NAME DEPT_NAME TOT_CRED TAKES STID TOT_CRED TAKES STID COURSE_ID SEC_ID SEMESTER YEAR GRADE TEACHES ID COURSE_ID SEMESTER YEAR TIME_SLOT ME_SLOT_ID DAY START_TIME END_TIME