Understanding Postgres IN Clause with Subquery: A Deep Dive into Complex Queries for Power Users