Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2015 Porto Portugal September 7 11 2015 Proceedings Part 2 Lnai 9285

Authors: Annalisa Appice ,Pedro Pereira Rodrigues ,Vitor Santos Costa ,Joao Gama ,Alipio Jorge ,Carlos Soares

1st Edition

3319235249, 978-3319235240

More Books

Students also viewed these Databases questions