💡 This example will show how you can correlate events using a LATERAL join. A recent addition to the SQL standard is the LATERAL join, which allows you to combine the power of a correlated subquery ...

SELECT i1.i, SUM(r2.k), COUNT(*) FROM integers i1, LATERAL (SELECT i1.i+i2.i FROM integers i2, LATERAL (SELECT i2.i+i3.i FROM integers i3) r3) r2(k) GROUP BY i1.i ORDER BY i1.i; ...