Unioning and Grouping Rows with SQL Window Functions, Common Table Expressions, and Subqueries for Data Analysis

Using Grouping Sets to Reference Values in First Selects from Second Selects within Unions in PostgreSQL

Optimizing SQL for Two Different Categories: Postgres Edition - Performance Optimized Query for PostgreSQL