The Logo Count
Loopwire is a small business-to-business software company, and the quarterly investor update opens with a single figure: how many companies have ever signed up. Sales calls them 'logos', because each one is a logo on the slide. There is room for one number, not a list, and it has to cover the whole history — companies that have since walked away were still customers once, and the slide counts them.
accounts — one row per customer company. industry is the sector that company works in; signup_date is the day it created its Loopwire account.
| id | company_name | industry | signup_date |
|---|---|---|---|
| 1 | Northwind Traders | retail | 2022-11-03 |
| 2 | Vertex Analytics | software | 2022-12-15 |
| 3 | Bluepeak Logistics | logistics | 2023-01-20 |
| 4 | Fernwood Studio | media | 2023-02-05 |
| 5 | Cobalt Health | healthcare | 2023-02-18 |
| 6 | Ridgeline Capital | finance | 2023-03-01 |
| 7 | Sable & Co | retail | 2023-03-22 |
| 8 | Hearth Robotics | manufacturing | 2023-04-10 |
The table already exists in the database — there is nothing to create or load.
Task: Write a query that returns one row and one column, total_accounts, holding how many companies appear in accounts. No company is left out.
Example output
If the book of business held thirty-four companies, the single row would read:
| total_accounts |
|---|
| 34 |
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