avg-salaries-where.md 754 B

% 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