Using the WHERE clause
The WHERE clause is used to filter out the items that do not satisfy a condition given by an expression.
The WHERE keyword should be followed by a simple or conditional
expression that returns a
Boolean:
WHERE expressionYou can specify several conditions using logical operators. For
example:
WHERE hasValue(rating) && rating > 650This clause should be used after a FROM, an UNNEST or a JOIN clause. If the query block contains a LET clause, the WHERE should be placed after it.