SQL Quest › SQL Interview Questions › Conditional Logic
Membership Display Labels
The marketing team renders membership tiers in customer-facing emails and the brand team enforces label consistency. Convert raw membership values into display labels — case-sensitive, exact strings:
- 'gold' → 'Gold Tier'
- 'silver' → 'Silver Member'
- 'bronze' → 'Bronze Trial'
- anything else (including NULL) → 'No Tier'
Show customer_id, name, membership, display_label. Order by customer_id ascending.
Note the comparison direction: membership values in the table are lowercase, but the OUTPUT labels are Title Case. Mixing those up is the most common typo on this kind of question.
Solve it in the browser editor →
Runs on SQLite in your browser, graded against the expected result, no signup. A wrong answer gets a diagnosis, not just "incorrect".
Schema
customers
| customer_id | name | signup_date | membership | total_orders | |
|---|---|---|---|---|---|
| 1 | John Smith | john.smith@email.com | 2023-01-15 | Gold | 15 |
| 2 | Emma Wilson | emma.wilson@email.com | 2023-03-20 | Silver | 8 |
| 3 | Michael Brown | michael.brown@email.com | 2023-02-10 | Gold | 12 |
Expected output: display_label = 'Gold Tier'
Hint
Concepts
SELECT CASE
Practise the topic: SQL practice questions · CASE WHEN practice
In these company practice sets
A SQL Quest challenge matched to patterns reported for these companies — not a question any of them has published.
Related questions
Where would this cost you points in an interview?
Ten questions, no signup: a Skillmap across nine SQL skills and the one to fix first.
Take the readiness test