Intersecting Array Aggregations in Postgres Using LATERAL Join

Grouping Rows in SQL While Calculating Average Based on Certain Conditions

PostgreSQL Concurrency Issues with Multiple Updates to the Same Row