How to Delete Specific Rows from a SQLite Table Using ROW_NUMBER()

Recursive CTEs, Row Numbers, and Partitioning: A Powerful Combo for Gaps-and-Islands Problems