% This is generated by ESQL's AbstractFunctionTestCase. Do not edit it. See ../README.md for how to regenerate it.
FROM employees
| KEEP emp_no, salary
| INLINE STATS avg_lt_50 = ROUND(AVG(salary)) WHERE salary < 50000,
avg_lt_60 = ROUND(AVG(salary)) WHERE salary >=50000 AND salary < 60000,
avg_gt_60 = ROUND(AVG(salary)) WHERE salary >= 60000
emp_no:integer | salary:integer | avg_lt_50:double | avg_lt_60:double | avg_gt_60:double |
---|---|---|---|---|
10001 | 57305 | 38292.0 | 54221.0 | 67286.0 |
10002 | 56371 | 38292.0 | 54221.0 | 67286.0 |
10003 | 61805 | 38292.0 | 54221.0 | 67286.0 |
10004 | 36174 | 38292.0 | 54221.0 | 67286.0 |
10005 | 63528 | 38292.0 | 54221.0 | 67286.0 |