FROM employees
| KEEP languages, salary
| INLINE STATS languages1 = MV_AVG(languages), avg = AVG(salary) BY languages
| INLINE STATS languages2 = SUM(languages1), avg = AVG(salary)

org.elasticsearch.xpack.esql.VerificationException: Found 1 problem
line 95:3: Output has changed from [[salary{f}#625, languages1{r}#610, languages{f}#621, languages2{r}#617, avg{r}#620]] to [[salary{f}#625, languages{f}#621, languages2{r}#617, avg{r}#620]].
        at org.elasticsearch.xpack.esql.optimizer.LogicalPlanOptimizer.optimize(LogicalPlanOptimizer.java:125)
        at org.elasticsearch.xpack.esql.session.EsqlSession.optimizedPlan(EsqlSession.java:953)
        at org.elasticsearch.xpack.esql.session.EsqlSession$1.lambda$onResponse$1(EsqlSession.java:243)
        at org.elasticsearch.server@9.3.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$ResponseWrappingActionListener.onResponse(ActionListenerImplementations.java:261)
...