multi-agg-multi-grouping.md 705 B

% This is generated by ESQL's AbstractFunctionTestCase. Do not edit it. See ../README.md for how to regenerate it.

FROM employees
| WHERE still_hired
| KEEP emp_no, languages, salary, hire_date
| EVAL tenure = DATE_DIFF("year", hire_date, now())
| DROP hire_date
| INLINE STATS avg_salary = AVG(salary), count = count(*) BY languages, tenure
emp_no:integer salary:integer avg_salary:double count:long languages:integer tenure:integer
10001 57305 51130.5 2 2 39
10002 56371 40180.0 3 5 39
10004 36174 30749.0 2 5 38
10005 63528 63528.0 1 1 36
10007 74572 58644.0 2 4 36