https://softwarepatternslexicon.com/sql/advanced-sql-patterns/
12. Advanced SQL Patterns