![sql - Accessing outer-query context as part of a GROUP BY to get a JOIN for a derived MIN value (postgres) - Stack Overflow sql - Accessing outer-query context as part of a GROUP BY to get a JOIN for a derived MIN value (postgres) - Stack Overflow](https://i.stack.imgur.com/WaUJ9.png)
sql - Accessing outer-query context as part of a GROUP BY to get a JOIN for a derived MIN value (postgres) - Stack Overflow
![join - How to apply outer limit offset and filters in the subquery to avoid grouping over the complete table used in subquery in Postgresql - Database Administrators Stack Exchange join - How to apply outer limit offset and filters in the subquery to avoid grouping over the complete table used in subquery in Postgresql - Database Administrators Stack Exchange](https://i.stack.imgur.com/o9X5t.png)
join - How to apply outer limit offset and filters in the subquery to avoid grouping over the complete table used in subquery in Postgresql - Database Administrators Stack Exchange
![postgresql - Postgres choosing a query plan that is more expensive by its own estimates - Stack Overflow postgresql - Postgres choosing a query plan that is more expensive by its own estimates - Stack Overflow](https://i.stack.imgur.com/3KVNJ.png)