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