Ranking Multiple Groups of Records Over Multiple Columns Using SQL Window Functions

Using SQL Window Functions to Find Records with Last 3 Same Status