search

fasterthanlime / cs322

CS-323 project
2 stars 1 forks source link

Implement query N #23

Closed nddrylliog closed 12 years ago

nddrylliog commented 12 years ago

List the last and first names of the top 30 TENDEX players, ordered by descending TENDEX value (Use season stats). (TENDEX=(points+reb+ass+st+blk‐missedFT‐missedFG‐TO)/minutes)

greut commented 12 years ago

I've taken the best TENDEX since it's said to use the season stats and not the career stats (what @sebasti4n tried to achieve). Can someone double check since many other queries rely on that TENDEX.

nddrylliog commented 12 years ago

@greut note that for #24, which is very similar, you need to use playoff stats instead. I've assigned you to it since it seems only logical, should be just a few adjustments from this one.

SeZuo commented 12 years ago

I've uploaded the manual computation of the tendices. 7d07d6558daa377505a1e81b90e54d5cdde57d41

It doesn't seem to fit the query's results line to line but the diff is not big. Someone can check I've not made a mistake there either?

My blind guess is the rounding algorithm used by SQL is not the same as in the spreadsheet.

greut commented 12 years ago

The full document could help seeing how you computed it, no?

SeZuo commented 12 years ago

@greut

It is the full document.

Tendex is the last col of the first sheet. The formula can be seen in the top bar if you click on any tendex cell (using libreoffice calc).

On the second sheet you may see the two query results side by side.

You may select a column (for instance the X tendex column) and then sort it using Data > Sort (extend the selection).

Quite convenient.