直接计算分组汇总
A
1 =demo.query("select EID, NAME+?+SURNAME as FULLNAME, GENDER, STATE, BIRTHDAY, SALARY from EMPLOYEE"," ")
2
=A1.groups(STATE:State;count(~):Count)
3
=A1.groups(STATE:State,GENDER:Gender;count(~):Count)

A2与A3中的结果分别和上例中A4与A5中的结果相同: