Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!