对派生的SQL值执行算术运算

I'm doing some statistics based on a database of states. I would like to output the rank of a state and it's percentage as compared to the other states (i.e. state X's value is higher then 55% of the other states' value).I'm doing some statistics based on a database o