[Functions/Group By/Having - Chap 6] Group By: Using the database provided, Write and Execute SQL SELECT statements, using GROUP BY, to get the following information: Group By: 1.) How many classes are scheduled in each room? 2.) How many sections of each course are there being taught? 3.) Which courses have only 1 section being taught? 4.) What is the avg gpa for all students from each different state? 5.) Which states have an avg gpa higher than 3.0 ? 6.) How many courses is each instructor teaching? 7.) Do we have more 3 credit hour courses or 5 credit hour courses. (use Group by to answer this question) 8.) How many instructors do we have from each state? 9.) Same as \#8 above, but only list the states that have 3 or more instructors. 10.) How many students are there from each state? 11.) Same as \#10 above, but only list the states that have 2 or more students. USE the StudentSchedule Table for the last questions! 12.) How many students are there in each each Section being taught? 13.) Which Sections have less than 3 students? Courses Record: is 1 of 14 e No fiter Search Courses CourselD . CourseName Description . Click to Add . CISCis Instructors CIS CIS Custom Custom Group 1 ^ Unassigned O... Courses Instructors Secfions Students Studentschedule Students Jnassigned O... Courses Instructors Sections Students Studentschedule \begin{tabular}{|rrr} StudentID & CRN Click to Add \\ 11 & 30106 \\ 11 & 30111 \\ 11 & 30116 \\ 12 & 30105 \\ 12 & 30106 \\ 13 & 30109 \\ 13 & 30110 \\ 13 & 30111 \\ 14 & 30101 \\ 15 & 30103 \\ 15 & 30107 \\ 15 & 30115 \\ 16 & 30101 \\ 16 & 30103 \\ 16 & 30110 \\ 10 & 0 \\ \hline \end{tabular}