Attached are 2 queries provided by the Frank Price of the Florida Natural Areas Inventory. The queries run surprisingly fast, even the more complicated one but they don’t say why the rank was changed. There is also a third query attached  (s_rank_changes.sql) which was submitted by Jodi Shippee, which also runs quickly.