PostgreSQL Subquery and CTE Optimization

Every SELECT in PostgreSQL is made of smaller SELECTs, even when it doesn't look that way. WHERE col...