## [answered] Bowling League Database 1. "Do any team captains have

Bowling League Database

1.??Do any team captains have a raw score that is higher than any other member on the team??

(Hint: You find out the top raw score for captains by JOINing teams to bowlers on captain ID and then to bowler scores. Use a HAVING clause to compare the MAX value for all other members from a subquery.)

You can find the solution in CH14_Captains_Who_Are_Hotshots (0 rows). (There are no captains who bowl better than their teammates!)

2.??Display for each bowler the bowler name and the average of the bowler?s raw game scores for bowlers whose average is greater than 155.?

(Hint: You need a simple HAVING clause comparing the AVG to a numeric literal.)

You can find the solution in CH14_Good_Bowlers (17 rows).

3.??List the last name and first name of every bowler whose average raw score is greater than or equal to the overall average score.?

(Hint: We showed you how to solve this in?Chapter 12?in the ?Sample Statements? section with a subquery in a WHERE clause. Now solve it using HAVING!)

You can find the solution in CH14_Better_Than_Overall_Average_HAVING (17 rows).

School Scheduling Database

1.??List all staff members and the count of classes each teaches.?

(Hint: Use the COUNT aggregate function.)

You can find the solution in CH11_Staff_Class_Count (27 rows).

2.??Display students enrolled in a class on Tuesday.?

(Hint: Build a filter using IN.)

You can find the solution in CH11_Students_In_Class_Tuesdays (18 rows).

3.??List the subjects taught on Wednesday.?

(Hint: Build a filter using IN.)

You can find the solution in CH11_Subjects_On_Wednesday (34 rows).

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 18, 2020

Solution~0001005749.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 18, 2020

EXPERT

Tutor