Group By : Using the database provided, Write and Execute SQL SELECT statements, using GROUP BY, to get the following information:

Group By:

How many classes are scheduled in each room?

How many sections of each course are there being taught?

Which courses have only 1 section being taught?

What is the avg gpa for all students from each different state?

Which states have an avg gpa higher than 3.0?

How many courses is each instructor teaching?

Do we have more 3 credit hour courses or 5 credit hour courses.(use Group by to answer this question)

How many instructors do we have from each state?

Same as #8 above, but only list the states that have 3 or more instructors.

How many students are there from each state?

Same as #10 above, but only list the states that have 2 or more students.

USE the StudentSchedule Table for the last questions!

How many students are there in each each Section being taught?

Which Sections have less than 3 students?

Table Tools Access Sign in File Home Create External Dato Database Tools Fields abe Tell me what you want to do Custom Custom Group Unassigned Objects Courses Instructors sections students CourselD CourseName Description CreditHours , Click to Add r Concepts Intro to Computers Hardware Maintainence Explore how an Operating System works Learning about SQL Intro to Programming Networking Fundamentals Develop Web-pages using HTML Intro to C# Programming Advanced Cf Programming Intro to Java Intermediate Java Topics Object Oriented Analysis and Design Capstone Project Class Using Java to build Web Applications IST 1001 CIST 1122 CIST 1130 CIST 1220 CIST 1305 CIST Hardware Maintainence Course Operating Systems SQL Programming Program Design and Development Networking Fundamentals Web Development I Cf Programming I C# ProgrammingI Java Programming I Java Programming lI Analysis and Design - 1401 10 CIST 15 CIST 2341 CIST 2342 CI ST 2371 CIST 2372 CIST 2921 CIST 2931Systems Project ST 3273 Java Programming II Record: l-M 1 of 14 1 K: No Filter | Search Datasheet View O Type here to search 1:36 PM 2/1/2018