String Filter

WHERE clause filters data before aggregation using string equality.

Interactive Example

Try It

TABLE
  WHERE gender = 'Female'
  ROWS occupation
  COLS education * income.sum
;

Dataset:samplesoccupation, education, gender, income

Try Variations

Query Breakdown

• WHERE gender = 'Female' - Filters to rows where gender equals 'Female'

String values must be enclosed in single quotes. Use IS NULL / IS NOT NULL for null checks.

Related Examples

• Numeric Filter - Numeric comparison operators
• Compound Filter - Combine multiple conditions with AND/OR