Skip to content

Compound Filter ​

Multiple conditions combined with AND or OR operators.

Interactive Example ​

Try It
TABLE
  WHERE gender = 'Female' AND income > 50000
  ROWS occupation
  COLS education * income.mean
;
Dataset:samplesoccupation, education, gender, income
Try Variations

Query Breakdown ​

  • WHERE gender = 'Female' AND income > 50000 - Combines a string equality filter with a numeric comparison using AND

Both conditions must be true for a row to be included. Use OR when either condition should match.

Powered by Malloy and DuckDB