Database: video_game
Question: What are the names and colleges of all players, ordered by rank of year descending?
SQL:
SELECT Player_name ,  College FROM player ORDER BY Rank_of_the_year DESC