SQL

Use the university schema for the following questions Figure 2.9 Schema diagram for the university database. 1. Find the IDs of students who are taking classes in 2018 and do not have an assigned advisor 2. Display the name and total institution credits taken (not tot cred which includes transfer credits) of students that do not have an assigned advisor (across all years). 3. Find the total instructor salary by department name, and display it by the sum of salary descending, and the department name ascending