| A | |
| 1 |
 =demo.query("select * from EMPLOYEE")
|
| 2 |
[?<35,?<=45,null]
|
| 3 |
=A1.enum(A2,age(BIRTHDAY))
|
| 4 |
=A3.new(A2(#):Group,~.count():Count,round(~.avg(SALARY),2):AvgSalary)
|
A4中运算结果如下:
公司需要统计各个年龄段的工资水平。请从数据库中的EMPLOYEE表中取出员工数据，计算30岁以下、30~40岁以及40岁以上员工的人数以及平均工资。
解答：
| A | |
| 1 |
=demo.query("select * from EMPLOYEE")
|
| 2 |
[?<35,?<=45,null]
|
| 3 |
=A1.enum(A2,age(BIRTHDAY))
|
| 4 |
=A3.new(A2(#):Group,~.count():Count,round(~.avg(SALARY),2):AvgSalary)
|
A4中运算结果如下: