% 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 |