Question: CIST 1220: SQL Assign #6 (40 Points) [Functions/Group By/Having Chap 6] Group By : Using the database provided, Write and Execute SQL SELECT statements, using

CIST 1220: SQL Assign #6 (40 Points) [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: 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

CIST 1220: SQL Assign #6

(40 Points)

[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:

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?

Courses CourseID CourseName ption reditHou Intro to Computers 4 ST 1001 Computer Concepts IST 1122 Hardware Maintainence Course Hardware Maintainence IST 1130 IST 1220 SQL Programming IST 1305Program Design and Development Intro to Programming IST 1401 IST 1510 Web Development I ST 2341 C# Programming I IST 2342|C# Programming 11 IST 2371 Java Programming I IST 2372 Java Programming II IST 2921 Analysis and Design IST 2931Systems Project IST 3273Java Programming III ing Systems plore how an Operating System works 4 ing about SQL Networking Fundamentals Intro to C# Programming rking Fundamentals evelop Web-pages using HTML Advanced C# Programming Intro to Java Intermediate Java Topics bject Oriented Analysis and Design apstone Project Class sing Java to build Web Applications

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

CIST 1220: SQL Assign #6 (40 Points) [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...

CIST 1220: SQL Assign #5 (40 Points) [Order By/Functions Chap 4 & Chap6] Using the database provided, Write and Execute SELECT statements to get the following information: Order By : List of...

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...

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...

CIST 1 2 2 0 : SQL Assign # 1 0 ( 4 0 Points ) [ More Joins Chap 7 ] Using the database provided, Write and Execute SELECT statements to get the following information: More Joins ( Multiple Table...

CIST 1220: SQL Assign #10 (40 Points) [More Joins Chap 7] Using the database provided, Write and Execute SELECT statements to get the following information: More Joins(Multiple Table Joins) How many...

CIST 1220: SQL Assign #4 (40 Points) [More SELECTS Chap 4] Using the database provided(Access Database is in Blackboard under Lessons/Week #3). Write and Execute SELECT statements to get the answers...

CIST 1220: SQL Assign #7 (40 Points) [Creating Tables Chap 11] Using the design that you created in Assign #2(or see my correct answers under Week #7), we are now going to build the tables using SQL....

CIST 1220: SQL - Assign \#7 (40 Points) [Creating Tables - Chap 7] 1.) Using the design that you created in Assign \#2(or see my correct answers under Week \#7), we are now going to build the tables...

2. Name and describe the five stages of social play first explained by Mildred Parten. (5+ sentences) 3. Describe the three parenting styles identified by Baumrind. Note: The neglectful/uninvolved...

What are some major social responsibility issues? Give an example of each.

Bonita is the primary provider of spirit apparel for many high schools. Management has been evaluating two of its key products for changes in selling price and sales volume in comparison to...

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...

=+replay this conversation in your mind, think about how well you did in terms of empathic listening (see page 37). For example, did you find yourself being critical when the person really just...

=+page 39, rate yourself using always, frequently, occasionally, or never on these positive listening habits. In a report no longer than one page, summarize your analysis and identify specific areas...

=+9. Interpersonal Communication: Listening to Empathize [LO-4] Think back over conversations you have had with friends, family members, coworkers, or classmates in the past week. Select a...