Postgres Subqueries: CTEs, Materialized Views, Window Functions, LATERAL Join | Hacker News Reader