Sort
A
1
=demo.query("select EID, NAME+?+SURNAME as FULLNAME, GENDER, STATE, BIRTHDAY, SALARY from EMPLOYEE"," ").derive(interval@y(BIRTHDAY,now()):Age)
2
=A1.sort(STATE)
3
=A1.sort(SALARY:-1)
4
=A1.sort(SALARY:-1, FULLNAME)

Of A2 the computation results are as follows:

Of A3 the computation results are as follows:

Of A4 the computation results are as follows: