Query Run
SELECT ROW_NUMBER() OVER( PARTITION BY YEAR(rev_timestamp) ORDER BY... 2 days ago