Fidelity International interview question

SQL queries which needs to be implemented by Rank Analytical Functions.