SQL Queries for Bowling Tournament Analysis and StatisticsPart 11.SELECTCOUNT(*) AS "Total Bowlers" FROM BowlersWHEREBowlerCity = 'Bothell'ANDBowlerState = 'WA';2.SELECTCOUNT(*) AS "WINNERS" FROM BOWLER_SCORESWHEREMatchID = 14ANDGameNumber = 2ANDWonGame = 1;3.SELECTCOUNT(*) AS "Games Won"FROMBOWLER_SCORESWHEREBowlerID = 8ANDWonGame = 1;
Page 2
Preview Mode
This document has 6 pages. Sign in to access the full document!