PostgreSQL SQL interview preparation covering joins, CTEs, window functions, query optimization, and execution plans.