WHERE clause for filtering in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of the WHERE clause in a database query?

The WHERE clause is used to filter records and return only those that meet a specific condition.

beginner

How do you write a WHERE clause to find rows where the value in column A is greater than 10?

You write: WHERE A > 10

intermediate

Can the WHERE clause be used with multiple conditions? How?

Yes, by using AND or OR to combine conditions, for example: WHERE A > 10 AND B = 'Yes'

beginner

In Google Sheets QUERY function, how do you write a WHERE clause to filter rows where column B equals 'Apple'?

Use: WHERE B = 'Apple' inside the QUERY function's query string.

beginner

What happens if you omit the WHERE clause in a query?

The query returns all rows without filtering any data.

What does the WHERE clause do in a query?

A Sorts the rows

B Joins two tables

C Filters rows based on a condition

D Deletes rows

The WHERE clause filters rows to include only those that meet the condition.

Which of these is a valid WHERE clause condition in Google Sheets QUERY to filter rows where column A is greater than 5?

A WHERE 5 > A

B WHERE > 5 A

C WHERE A =

D WHERE A > 5

The correct syntax is 'WHERE A > 5' to filter rows where column A is greater than 5.

How do you combine two conditions in a WHERE clause to require both to be true?

A Use AND

B Use OR

C Use NOT

D Use THEN

AND combines conditions so both must be true for a row to be included.

In Google Sheets QUERY, how do you filter rows where column C is exactly 'Yes'?

A WHERE C == 'Yes'

B WHERE C = 'Yes'

C WHERE C equals 'Yes'

D WHERE C contains 'Yes'

The correct syntax is WHERE C = 'Yes' to match exact text.

What will happen if you write a query without a WHERE clause?

A All rows are returned

B No rows are returned

C Only the first row is returned

D An error occurs

Without WHERE, the query returns all rows without filtering.

Explain how the WHERE clause helps in filtering data in a query.

Think about how you pick only certain items from a list.

Describe how to use multiple conditions in a WHERE clause.

Consider how you might say 'I want this AND that' or 'this OR that'.