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.