OK, found the answer.... well at least how to do the query. I just need to wrap it in a view.

SELECT a1.name, a1.score, COUNT(a2.score) Rank

FROM Test a1, Test a2

WHERE a1.score...