Skip to content
Solved Assignments

SQL Queries for Bowling Tournament Analysis and Statistics

Development of SQL queries to analyze and visualize bowling tournament data.

Preview 2 of 6 pages

See the first 2 pages exactly as they appear in the document.

  1. Page 1
    Read page 1 as text

    SQL Queries for Bowling Tournament Analysis and Statistics Part 1 1. SELECT COUNT(*) AS "Total Bowlers" FROM Bowlers WHERE BowlerCity = 'Bothell' AND BowlerState = 'WA'; 2. SELECT COUNT(*) AS "WINNERS" FROM BOWLER_SCORES WHERE MatchID = 14 AND GameNumber = 2 AND WonGame = 1; 3. SELECT COUNT(*) AS "Games Won" FROM BOWLER_SCORES WHERE BowlerID = 8 AND WonGame = 1;

  2. Page 2

4 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.

Unlock the full document

More Information Technology study materials

See all

Study this document with CramX

Once it is in your library, every tool can work from it.