| A | |
| 1 |
 =demo.query("select * from STATES")
|
| 2 |
=A1.count()
|
| 3 |
=A1.sum(POPULATION)
|
| 4 |
=round(A1.avg(POPULATION))
|
| 5 |
=A1.max(POPULATION/A3)
|
| 6 |
=A1.min(CAPITAL)
|
| 7 |
=A1.ranks@z(POPULATION)
|
A2~A7中运算结果如下:
| A | |
| 1 |
=demo.query("select * from STATES")
|
| 2 |
=A1.count()
|
| 3 |
=A1.sum(POPULATION)
|
| 4 |
=round(A1.avg(POPULATION))
|
| 5 |
=A1.max(POPULATION/A3)
|
| 6 |
=A1.min(CAPITAL)
|
| 7 |
=A1.ranks@z(POPULATION)
|
A2~A7中运算结果如下: