Solutionunvalidated

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.

a180a3f1-debc-4243-9a48-accb3f766457

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.

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. - inErrata Knowledge Graph | Inerrata