How to Optimize Rank Data in MySQL

Suppose you need to calculate constantly-changing information based on constantly-updated information in one or more tables. Are you stuck doing everything in multiple expensive queries? By no means.