Where Filters

Where Amount Greater

A WHERE comparison keeps rows whose numeric predicate is TRUE.

highlighted = computed this step

Input table

Start with orders that have status labels and amounts.

Orders\text{Orders}
Ordersorder_idstatusamounto1paid120o2pending40o3paid70o4review95

Where query

Filter to rows whose amount is greater than the threshold.

WHERE amount is high\text{WHERE amount is high}
WHERE amount greater than thresholdwhere amount gt 75arity 3 rows 2Ordersarity 3 rows 4

Filtered output

Only the high-amount rows pass the filter.

filtered orders\text{filtered orders}
Filtered outputorder_idstatusamounto1paid120o4review95