#data

The Query That Made Me Stop Writing Self-Joins

The query was four hundred lines long. It had three nested subqueries, two of which selected from the same table with slightly different date filters, and a self-join that existed purely so one row co...