SQL CTE Solution: Identifying Soft Deletes with Consecutive Row Changes

Understanding How to Use SQL Query Like Operator Without Null Values