WHERE clause for filtering in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to filter rows where the value in Col1 is greater than 10.

Google Sheets

SELECT * WHERE Col1 [1] 10

Drag options to blanks, or click blank then click option'

A=

B>

C<=

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' will filter the wrong rows.

Using '=' will only select rows equal to 10, not greater.

The WHERE clause filters rows where Col1 is greater than 10, so the operator should be >.

2fill in blank

medium

Complete the code to filter rows where the value in Col2 is exactly 'Yes'.

Google Sheets

SELECT * WHERE Col2 [1] 'Yes'

Drag options to blanks, or click blank then click option'

A=

B>

C<>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>' or '<' will not check for exact equality.

Using '<>' means 'not equal', which is the opposite.

The WHERE clause checks if Col2 equals 'Yes', so the operator should be =.

3fill in blank

hard

Fix the error in the code to filter rows where Col3 is not equal to 5.

Google Sheets

SELECT * WHERE Col3 [1] 5

Drag options to blanks, or click blank then click option'

A=

B>

C<>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '=' will select rows equal to 5, not different.

Using '>' or '<' will filter based on greater or less, not inequality.

The operator <> means 'not equal to' in Google Sheets queries.

4fill in blank

hard

Fill both blanks to filter rows where Col4 is less than 20 and Col5 equals 'Active'.

Google Sheets

SELECT * WHERE Col4 [1] 20 AND Col5 [2] 'Active'

Drag options to blanks, or click blank then click option'

A<

B>

C=

D<>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>' instead of '<' for Col4.

Using '<>' instead of '=' for Col5.

Col4 should be less than 20, so use '<'. Col5 should equal 'Active', so use '='.

5fill in blank

hard

Fill all three blanks to filter rows where Col6 is greater than 50, Col7 is not equal to 'No', and Col8 equals 100.

Google Sheets

SELECT * WHERE Col6 [1] 50 AND Col7 [2] 'No' AND Col8 [3] 100

Drag options to blanks, or click blank then click option'

A<

B<>

C=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up '<' and '>' operators.

Using '=' instead of '<>' for 'not equal'.

Col6 should be greater than 50, so use '>'. Col7 should not equal 'No', so use '<>'. Col8 should equal 100, so use '='.