Solving the Gap-and-Islands Problem with SQL or Apache Spark

Removing Duplicates from Self-Joins in SQL: Best Practices and Examples