EasyWHERE & Filtering

Find all premium tier customers

The query

SQL

SELECT cust_id, name, email, country
FROM customers
WHERE tier IN ('premium', 'enterprise', 'gold')
ORDER BY tier, name;

Tested against PostgreSQL 16

Note

“IN clause for multi-value matching. Add more tiers without changing query structure.