The Subscriber Number
StreamVerse opens every all-hands with the same slide, and the same number sits at the top of it: how many people are subscribed right now. Nobody wants a list of names on that slide — they want the one figure, in a column the deck can point at.
subscribers — one row per person who pays for StreamVerse. plan is one of basic, standard or premium; country is a two-letter market code; signup_date is the day they signed up.
| 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 |
The table already exists in the database — there is nothing to create or load.
Task: Write a query that returns exactly one row with one column, total_subscribers, holding how many subscribers are on file.
Example output
If three hundred and twelve subscribers were on file, the single row would read:
| total_subscribers |
|---|
| 312 |
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