Write a SQL query using window functions to identify the most recent risk rating change for a set of monitored organizations.
