won/loss average

[longway]

I sure hope someone can help me. I am currently the world's most confused person. I am trying to run this query:

SELECT * FROM nfcnorth
Order By Won / (Won + Loss)DESC

Here are the results:

TeamID TeamName Won Loss

CHC Chicago 2 3
DET Detroit 1 4
GBP GreenBay 3 3
MIN Minnesota 3 2

This isn't even close! How can this be?? I am totally baffled. HELP!

 

[kulrom]

Hi Longway
Just a friendly reminder to try to avoid double posting.
Thanks for understanding

thread continues here:
http://www.vbdotnetforums.com/showthread.php?t=5123

I suppose your problem should be resolved so far. I tried and it works good for me.

[color=blue]select[/color] * [color=blue]from[/color] nfcnorth [color=blue]order by[/color] result [color=darkgreen]'where result is calculated percentage and it should be enough[/color]

Regards