Database: video_game
Question: List names and colleges of all players in descending order of rank of the year.
SQL:
SELECT Player_name ,  College FROM player ORDER BY Rank_of_the_year DESC