Compute Group Summarization Directly
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)

Of A2 and A3 the results are the same to that of the A4 and A5 in previous example: