Scenarios
List the bowler's first and last names of all players on the Marlins Team. Hint: You will use a subquery to join the Bowlers and Team tables using the TeamID field. Display the number of games each bowler has played. Show the bowler's first and last name in the result data set. Hint: You will create a subquery using the bowler ID field to join the Bowler and Bowler Scores tables. You will also need to utilize the COUNT() function. List the last tournament date that the bowling team Swordfish played. Hint: Here you will create a subquery using the Teams and Tournaments tables connecting the TourneyID with the TeamsID fields using the MAX() function.
Display the captain's first and last name of the Manatees. Hint: Here you will use a subquery with the Bowlers and Teams tables.
List the names of all teams that have played on odd numbered lanes. Hint: Here you will use a subquery with the Teams and Tourney_Matches tables. Because this query will return multiple rows, you will need to use the IN or ALL keywords.
Display the names of all bowlers that have a handicap score greater than 200. Display the last name and handicap scores in the results. Here you will use a subquery with the Bowlers and Bowlers_Scores tables. Because this query will return multiple rows, you will need to use the IN or ALL keywords.
Part 2
Directions: After reviewing and completing the Unit 4 Guided Practice 1, create four scenarios using the following SQL syntax, clauses, and keywords.
Each scenario must include a subquery using data from multiple tables.
You need to include the where clause in at least three scenarios.
You need to use at least two of the following aggregate functions: COUNT(), SUM(), AVG(), MIN(), MAX()
Lastly, you will need to rename at least one resulting field in your result data set using the AS keyword.
**Feel free to include any other functions that you have learned in the guided practice exercises or previous SQL syntax to expand your learning experience.