All problems
Who's on the Premium Plan?
easySQLFiltering
StreamVerse's growth team is planning a premium-only beta.
subscribers
| id | name | plan | signup_date | country |
|---|---|---|---|---|
| 1 | Ana Torres | premium | 2022-11-01 | US |
| 2 | Ben Osei | basic | 2023-01-15 | UK |
| 3 | Chloe Martin | standard | 2023-02-20 | US |
| 4 | Dev Malhotra | premium | 2023-03-10 | IN |
| 5 | Ella Novak | basic | 2023-04-05 | UK |
Task: Write a query that returns the name of every subscriber on the 'premium' plan, sorted alphabetically by name.
Example output — shape only, on invented names.
| name |
|---|
| Bruno Salas |
| Mateo Ferrand |
Sign in to solve this problem
Reading problems is free for everyone — solving them (Run, Submit, and tracking what you've solved) needs an account.
Sign in