Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have a relation pitching (playerid, yearid, stint, ..., sv, ...) players can play multiple stints in a given year, but (playerid, yearid, stint) should
I have a relation pitching (playerid, yearid, stint, ..., sv, ...)
players can play multiple stints in a given year, but (playerid, yearid, stint) should be unique.
I need to find the number of players, COUNT(playerid), who had over 40 saves, sv>40, in any single year since 1975 using an sql query... Ex.
Player01, 1985, 1, ... , 30, ...
Player01, 1985, 2, ... , 20, ...
would increase COUNT because player01 got 50 saves in 1985, even
though it was in two separate stints
SQL, PostgreSQL
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