| 选 项 | 语法 |
| Project | select <expression> |
| Filter | where <expression>, distinct |
| Test | any(<expression>), all(<expression>) |
| Join | <expression> join <expression> on <expression> equals <expression> |
| Group |
group by <expression>, into <expression>, <expression> group join<decision> on <expression> equals |
| Aggregate | count([<expression>]), sum(<expression>), min(<expression>), max(<expression>), avg(<expression>) |
| Patition | skip [while] <expression>, take [while] <expression> |
| Set | union, intersect, except |
| Order | order by <expression>, <expression> [ascending | descending] |