PLEASE use the website or other SQL tool: https://www.db-book.com/university-lab-dir/sqljs.html

Use the university schema for the following questions Figure 2.9 Schema diagram for the university database. Use the online sQLite tool from db-book.com to write SQL statements for each of the questions below. Paste your solution SQL. statement under each question and upload the document to Canvas. 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