Also consider expressin this with a lateral join. Scroll a bit down here for a similar example. https://stackoverflow.com/questions/11472790/postgres-analogue

Also consider expressin this with a lateral join. Scroll a bit down here for a similar example. https://stackoverflow.com/questions/11472790/postgres-analogue-to-cross-apply-in-sql-server https://stackoverflow.com/questions/11472790/postgres-analog...