The 2023 Cohort
Loopwire is writing its annual growth review, and the section that takes the most work is the newest cohort: the companies that came on board during the 2023 calendar year. The reviewer wants them in the sequence they arrived, so the section can read as a story about the year rather than an alphabetical list. Two of the eight customers on file signed up before 2023 and belong to an earlier chapter.
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 two columns, company_name and signup_date, for the companies whose signup date falls in the 2023 calendar year, earliest signup first.
Example output
Shape only — these companies and dates are invented:
| company_name | signup_date |
|---|---|
| Larkspur Freight | 2023-01-08 |
| Quill & Bright | 2023-02-11 |
| Ironvale Systems | 2023-05-30 |
| Tidewater Farms | 2023-08-02 |
| Orbit Grocers | 2023-11-19 |
(...1 more row not shown)
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