WHERE
Filtering rows in the SELECT result based on a condition in row-oriented or column-oriented.
Example
SELECT key FROM my_table
WHERE value > 0;
Warning
Correlated subqueries in WHERE are not supported: a subquery cannot refer to columns or table aliases from an outer query. To select rows that have matching rows in another table, use LEFT SEMI JOIN. To select rows without matches, use LEFT ONLY JOIN.