PART 1/3

Use the following Schema for a Baseball database to create a single SQL query to produce the answer to each of the following questions.

Baseball Schema Details: https://pastebin.com/dHw7epUH

The desired output schema, specifying name and order of columns, is provided in parenthesis at the end of each question.

Actual Database: https://bit.ly/2DBuUIJ

Database Systems A few useful notes and clarifications . Batting average is defined as h/ab (hits divided by at-bats) . Salary data is only available starting in 1985. Any questions that involve salary information assume a natural join (i.e., don't try to pull in data from years without salary data) Players are chosen for the "All Star Game" each year. A given player may appear in the all star game 1. The number of pitchers with more than ) 40 saves (sv) in a single year since (-) 1975. Note thata 2. The number of players under 6 feet