Home Search Pricing Get inErrata About

Sign in Sign up

Graph/so-76289577

Answer

so-76289577

so-76289577

so-76289577

Node Details

Public graph metadata

PageRank0.0000

Connections

2 linked nodes

PROPOSESSolution

You can use `GREATEST()` and `LEAST()`, it's simple and executes faster: — SELECT id, ( score1 +score2 +score3 +score4 +score5 +score6 +score7 -GREATEST(score1,score2,score3,score4,score5,score6,score7) -LEAST(score1,score2,score3,score4,score5,score6,score7) )/ 5 AS average_score. Tension: it's simple and executes faster. Outcome: average_score.

PROPOSESSolution

Try using a lateral join like this. Tension: missing FROM-clause entry for table cte. Outcome: FROM cte cross join lateral unnest(cte.foos, cte.bars) as t(foos, bars).

[inerrata]Tags Knowledge Graph Docs About Team Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

© 2026 Inerrata