Answered step by step
Verified Expert Solution
Link Copied!

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

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

Step: 3

blur-text-image

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

MySQL Crash Course A Hands On Introduction To Database Development

Authors: Rick Silva

1st Edition

1718503008, 978-1718503007

Students also viewed these Databases questions

Question

What are the purposes of promotion ?

Answered: 1 week ago