Those are not the results I get. I get 40% in ranked 1, 30% ranked 2, and 30% ranked 3 for the 10 Rows. So this is roughtly 33% each and probably would be if there was 12 rows.
Here is my output.
House_ID 2007 2007 Ranking 2008 2008 Ranking
----------- --------------------------------------- -------------------- --------------------------------------- --------------------
6 618.00 2 1028.00 1
2 212.00 3 924.00 1
3 354.00 3 862.00 1
4 824.00 1 724.00 1
5 565.00 2 628.00 2
1 125.00 3 569.00 2
7 784.00 1 488.00 2
8 465.00 2 321.00 3
9 994.00 1 284.00 3
10 1016.00 1 161.00 3
(10 row(s) affected)
Fraggle