search

fasterthanlime / cs322

CS-323 project
2 stars 1 forks source link

Implement query S #28

Closed nddrylliog closed 12 years ago

nddrylliog commented 12 years ago

Compute which was the team with most wins in regular season during which it changed 2, 3 and 4 coaches.

nddrylliog commented 12 years ago

The énoncé is ambiguous :( are we supposed to:

1) Return one row per season (year) ? 2) One row for '2 different coaches for a season', one row for '3 different coaches for a season', one for '4 different coaches for a season' ?

This is very obscure to me ___

(@greut)

greut commented 12 years ago

I'd say it returns one team which has between 2 and 4 coach_seasons for a particular year (aka season) with the most wins that year compared to the other teams.

team | year | coaches_season_count | season_win

It's seems to be an easy one ;-)

greut commented 12 years ago

BETWEEN c'est plus joli que <= AND >=, my 2 cents