Google Sheets Query Clauses

The Google API Query Language includes nine clauses, where each of them has a unique intended purpose. They are optional, meaning that you don’t have to include all of them into one query.

One query string may contain several space-separated clauses that have to be written in this order: 

SELECT

WHERE,

GROUP BY

PIVOT

ORDER BY

LIMIT

OFFSET

LABEL

FORMAT.