Create queries that do the following: 1)List all games played at venue id 9 where the winning
Question:
Create queries that do the following:
1)List all games played at venue id 9 where the winning team scored more than 85 points. Display the gameid, venue id, winning team id, losing team id, winning team points and losing team points scored. Name the query game0.
2)List players, sorted by quality from highest to lowest, of players whose home state is NY or NJ and whose weight is over 175 pounds. Display their first name, last name, quality, home state and weight. Name the query player1.
3)List players who weight-to-height ratio is greater than 2.6. Display their first name, last name, height, weight and weight-to-height ratio. Display the weight-to-height ratio to one decimal place and with a caption of ratio. Name the query player2.
4)List players whose home state is not equal to their birth state. Display their first name, last name, home state and birth state. Name the query player3.
5)List all games where team #3 played. Display the game Id. Name the query game1.
Note: In class today our criteria tests were always against a constant, like state (NJ) or weight (185). You can in your criteria test, test against the value of a different field in the table.