Filtering & predicates
Exercise · SQL & Querying

Predict, then run it

Predict the output

tix(id, zone, day) = (1,lawn,sat),(2,lawn,sun),(3,vip,sat),(4,vip,sun). Saturday tickets for the lawn and vip zones — grouped correctly:

SELECT id FROM tix WHERE (zone='lawn' OR zone='vip') AND day='sat' ORDER BY id;

Predict the exact output.