Understanding Join On Sub-Queries in Postgres: Mastering the Technique with Common Table Expressions (CTEs) and Simplified Query Structures.