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.