I am not sure if this can be done in one swoop, but I think it would be nice.
I need to calculate the following
I'm hoping this isn't deceptively simple...
I assume that these ranks are columns and not calculated. if so, simple algebraic substitution says that:
CScore = (((ORank*.6)+(CRank*.4))-((BRank*.6)+(ARank*.4)))
SELECT (((ORank*.6)+(CRank*.4))-((BRank*.6)+(ARank*.4))) AS CScore FROM table...
If the ranks are instead calculated and you don't care about performance, you could do (nasty-looking) subselects or joins.