CIST 1220: SQL - Assign \#5 (40 Points) [Order By/Functions - Chap 5] Using the database provided, Write and Execute SELECT statements to get the following information: Order By: 1.) List of Students, first name and last name only, in alphabetical order by last name. 2.) List all students, only id, first name, last name. The student with the highest gpa should be listed first. 3.) Same as \#2 above except the student with the lowest gpa should be listed first. 4.) List all sections, all columns, sorted by instructor id. 5.) List all sections, all columns, sorted by roomNo. 6.) List all courses, all columns, sorted by creditHours 7.) List all students, all columns, sorted first by state, then within each state, sorted by gpa. 8.) Which student (give id, first name and last name) has the lowest gpa? Use order by to see a list of students in order by gpa, and read the name of the student with the lowest gpa. Aggregate Functions : 9.) What is the average gpa for all students? 10.) How many students are there from Illinois? 11.) If a student were to take three courses(CIST 1001, CIST 1122 and CIST 1130) how many credit hours would this student be taking? 12.) How many sections are being taught by the instructor with id 3 ? 13.) How many sections are being taught in room F1150? 14.) How many students are in the section with CRN=30115 ? (Hint: use StudentSchedule table.) 15.) How many students are there from Marietta, Ga? 16.) Which student from Georgia has the highest GPA? Courses Y RISK Microsoft has blocked macros from running because the source of this file is untrusted. Learn More Instructors Sections aft hac hlankad manme fram numninn hamanen the source of this file is untruste IITY RISK Microsoft has blocked macros from running because the source of