Postgres users love Common Table Expressions (CTEs) because they make complex SQL easy to read, create, edit, and reuse. Simplicity – CTEs let you break a query into smaller logical chunks, with subqueries defined at the top of the query. It is almost like giving a query book chapters. Build in parts – Since you can test each part of a CTE as its own query, you can build the query in parts that have been individually tested. You can also comment out parts of a CTE for testing and debugging. Reuse – You can reference the same CTE multiple times in a query, which saves repeating logic.

Postgres tip: Within the psql client you can use '\x auto' to auto format the output of queries based on the size of your screen so it wraps more cleanly in your terminal