Align Group
A
1 =demo.query("select EID, NAME+?+SURNAME as FULLNAME, GENDER, STATE, BIRTHDAY, SALARY from EMPLOYEE"," ")
2 [New York,Texas,California]
3
=A1.align@a(A2, STATE)
4
=A3.new(A2(#):State,~.count():Count)

Of A3 the grouping result is as follows. Each group is a TSeq on which you can click to view:

Of A4 the statistics result is as follows: