Filter
A
1
=demo.query("select NAME as STATE, ABBR, CAPITAL, POPULATION from STATES")
2
=A1.select(left(STATE,1)=="A")
3
=A1.select@1(POPULATION>6000000)
4 [M,N,W]
5
=A1.select(POPULATION>6000000 && A4.pos(left(STATE,1))>0)

Of A2 the computation results is as follows:

Of A3 the computation results is as follows:

Of A5 the computation results is as follows: