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

How to Use Window Functions to Account for Missing Days or Deployments in SQL Tables