PostgreSQL CTEs and Window Functions: Advanced Query Techniques