Grouping Rows in SQL While Calculating Average Based on Certain Conditions

Intersecting Array Aggregations in Postgres Using LATERAL Join

Working with Multiple Keys in JSON and Returning Only Rows with Values in PostgreSQL 9.5: Advanced Techniques for Efficient Querying