Grouping Rows in SQL While Calculating Average Based on Certain Conditions

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