/* ITEC 2120 DB Design & SQL Bowling EXTRA CREDIT 10 pts possible

No column should have a heading such as EXPR1000 Use the Bowling database for all questions submit your SQL code to the dropbox!

Table Queries */

-- 1. List all of the teams in alphabetical order. (10 rows)

-- 2. Show me all the bowling score information for each of our members Bowlers name should be in 1 column. (1344 rows)

-- 3. Show me a list of bowlers with their current average and handicap, and sort it in alphabetical order. Bowlers name should be in 1 column (32 rows)

-- 4. Show 2015 tournament dates for 2014 tournament records. (6 rows) HINT: Uses a DATEADD(interval, #DaystoBeAdded, fName) -- 5. List the name and phone number for each member of the league. Bowlers name should be in 1 column. (32 rows)

-- 6. Give me a list of the tournaments held during August 2012. (4 rows)

-- 7. What are the tournament schedules for Bolero, Red Rooster, and Thunderbird Lanes? (9 rows) -- 8. List the bowlers who live on the eastside (Bellevue, Bothell, Duvall, Redmond, and Woodinville) and whose handicap is between 45 and 55. (7 rows)

-- Inner Joins -- 9. List the bowling teams name and all the team members. (32 rows)

-- 10. Display the bowlers, the matches they played in, and the bowler game scores. (1344 rows)

-- 11. Find the bowlers who have the same average? This requires a self-join (56 rows)

-- Union -- 12. Find the bowlers, location and score who had a raw score of 165 or better at Thunderbird Lanes combined with bowlers who had -- a raw score of 150 or better at Bolero Lanes. (125 rows)

-- Subqueries -- 13. Show me all the bowlers and a count of games each bowled. (Use a subquery in the SELECT Clause. (32 rows)

-- 14. Show be tournaments that havent been played yet? (6 rows) (a) Complete with a subquery in the Where Clause and b) use an Outer Join)

-- 15. Find the bowlers (BowlerID, FirstName and LastName) who had a raw score of 170 or better at both Thunderbird Lanes and Bolero Lanes. (10 rows)

-- Aggregate Functions -- 16. What is the largest handicap held by any bowler at the current time? (1 row)

-- 17. Which locations hosted the very first tournaments? (Use a subquery to determine the first tourney date) (1 row)

-- Grouping -- 18. Display for each bowler, the bowler name, and the average of their raw game scores. Display highest average first! (32 rows) -- 19. Display each teams total match score for each tourney played.

-- Having --20. Display for each bowler, the bowler name, and the average of their raw game scores for bowlers whose average is greater than 155. (16 rows)