Question
I need just Query Syntax (no need numbers just start from 'select') 8. How many players that we know are deceased had a final game
I need just Query Syntax (no need numbers just start from 'select')
8. How many players that we know are deceased had a final game before 1/1/1920? ____ Select:
10. Using the Salaries table and a single statement, how many players, what was the total payroll AND average salary of the Seattle Mariners (TeamID: SEA) in 2010? ____ Select:
11. Using the salaries table, how many years of salary data are maintained by the Mariners? (Hint: https://www.w3resource.com/sql/aggregate-functions/count-with-distinct.php) ____ Select:
Using the Weather Database and Spokane2022 table:
14. What are the hottest and coldest temperatures ever recorded in Spokane (single statement)? ? ____ Select:
15. What is the overall average daily temperature in Spokane? (mean daily mean) ? ____ Select:
16. What is the average of all low temperatures in Celcius? ____
To convert temperatures in degrees Fahrenheit to Celsius, subtract 32 and multiply by .5556 (or 5/9). Select:
17. How many record lows were recorded in the year 1888? Be careful and test your results. ____ Select:
18. What is the most recent year that a record high was recorded? ____ Select: 19. Which Mariner (just PlayerID) had the greatest salary in 2012? Hint: First find the greatest Mariner salary for 2012. Then find the PlayerID with the salary for 2012. If you watch the course videos you know how to now combine them into a single statement. ____ Select:
20. Who, according to birthdate, was the earliest player ever to play Major League Baseball? ________________ Select:
21. Which living players, those without a date of death, have the same weight as the all-time average for baseball? ____ Select
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started