runtimetask COUNT / SUM / AVG / MIN / MAX · medium
Debug: count zero projects correctly
Return account_id and projects for every workspace created in June 2025. Workspaces without projects currently show 1. Fix the count.
what to return
- Columns
account_idprojectsin this order- Rows
- 306 rows · any order
- Skill
- Repair the query’s logic and confirm the fix on changed data. Refresher: Keep unmatched rows →
expected result
Your query should return exactly these columns and values. Run it and compare.
expected result306 rows · any order
| account_id | projects |
|---|---|
| 2895 | 1 |
| 2896 | 1 |
| 2897 | 0 |
first 3 of 306 rows
data you can query
Product / SaaS Analytics dataset: the first 6 rows of each table. Under each column name: the kind of value it holds, and which table it links to. Your queries run on all rows.
accounts7 columns · 3,200 rows
| account_idnumber · unique id | account_nametext | industrytext | company_sizetext | countrytext | acquisition_channeltext | created_atdate & time |
|---|---|---|---|---|---|---|
| 1 | Iron Capital Inc | Logistics | 11-50 | United States | organic | 2024-01-14 18:52:14 |
| 2 | Vector Data Co | Nonprofit | 51-200 | United Kingdom | social | 2024-01-15 13:21:52 |
| 3 | True Foods Inc | Healthcare | 201-1000 | United States | outbound_sales | 2024-01-19 11:22:02 |
| 4 | Meridian Works | Software | 11-50 | United States | organic | 2024-01-23 23:42:36 |
| 5 | Prism Health Group | Software | 1-10 | Germany | referral | 2024-01-25 11:43:43 |
| 6 | Beacon Supply Ltd | Media | 1000+ | United Kingdom | organic | 2024-01-27 20:19:28 |
- account_idnumber · unique id
- 1
- account_nametext
- Iron Capital Inc
- industrytext
- Logistics
- company_sizetext
- 11-50
- countrytext
- United States
- acquisition_channeltext
- organic
- created_atdate & time
- 2024-01-14 18:52:14
- account_idnumber · unique id
- 2
- account_nametext
- Vector Data Co
- industrytext
- Nonprofit
- company_sizetext
- 51-200
- countrytext
- United Kingdom
- acquisition_channeltext
- social
- created_atdate & time
- 2024-01-15 13:21:52
- account_idnumber · unique id
- 3
- account_nametext
- True Foods Inc
- industrytext
- Healthcare
- company_sizetext
- 201-1000
- countrytext
- United States
- acquisition_channeltext
- outbound_sales
- created_atdate & time
- 2024-01-19 11:22:02
- account_idnumber · unique id
- 4
- account_nametext
- Meridian Works
- industrytext
- Software
- company_sizetext
- 11-50
- countrytext
- United States
- acquisition_channeltext
- organic
- created_atdate & time
- 2024-01-23 23:42:36
- account_idnumber · unique id
- 5
- account_nametext
- Prism Health Group
- industrytext
- Software
- company_sizetext
- 1-10
- countrytext
- Germany
- acquisition_channeltext
- referral
- created_atdate & time
- 2024-01-25 11:43:43
- account_idnumber · unique id
- 6
- account_nametext
- Beacon Supply Ltd
- industrytext
- Media
- company_sizetext
- 1000+
- countrytext
- United Kingdom
- acquisition_channeltext
- organic
- created_atdate & time
- 2024-01-27 20:19:28
first 6 of 3,200 rows · your queries use all of them
projects6 columns · 9,962 rows
| project_idnumber · unique id | account_idnumber · links to accounts | created_by_user_idnumber · links to users | project_nametext | created_atdate & time | archived_atdate & time |
|---|---|---|---|---|---|
| 1 | 1 | 1 | Marketing Calendar | 2024-02-23 16:32:02 | NULL |
| 2 | 1 | 1 | Customer Onboarding 2 | 2024-02-23 16:33:07 | NULL |
| 3 | 1 | 1 | Website Redesign 3 | 2024-02-23 16:36:34 | 2024-05-15 08:53:27 |
| 4 | 1 | 2 | Marketing Calendar | 2024-01-27 00:29:22 | NULL |
| 5 | 1 | 2 | Sales Pipeline 2 | 2024-02-03 17:23:30 | NULL |
| 6 | 1 | 3 | Marketing Calendar | 2024-02-13 09:10:19 | NULL |
- project_idnumber · unique id
- 1
- account_idnumber · links to accounts
- 1
- created_by_user_idnumber · links to users
- 1
- project_nametext
- Marketing Calendar
- created_atdate & time
- 2024-02-23 16:32:02
- archived_atdate & time
- NULL
- project_idnumber · unique id
- 2
- account_idnumber · links to accounts
- 1
- created_by_user_idnumber · links to users
- 1
- project_nametext
- Customer Onboarding 2
- created_atdate & time
- 2024-02-23 16:33:07
- archived_atdate & time
- NULL
- project_idnumber · unique id
- 3
- account_idnumber · links to accounts
- 1
- created_by_user_idnumber · links to users
- 1
- project_nametext
- Website Redesign 3
- created_atdate & time
- 2024-02-23 16:36:34
- archived_atdate & time
- 2024-05-15 08:53:27
- project_idnumber · unique id
- 4
- account_idnumber · links to accounts
- 1
- created_by_user_idnumber · links to users
- 2
- project_nametext
- Marketing Calendar
- created_atdate & time
- 2024-01-27 00:29:22
- archived_atdate & time
- NULL
- project_idnumber · unique id
- 5
- account_idnumber · links to accounts
- 1
- created_by_user_idnumber · links to users
- 2
- project_nametext
- Sales Pipeline 2
- created_atdate & time
- 2024-02-03 17:23:30
- archived_atdate & time
- NULL
- project_idnumber · unique id
- 6
- account_idnumber · links to accounts
- 1
- created_by_user_idnumber · links to users
- 3
- project_nametext
- Marketing Calendar
- created_atdate & time
- 2024-02-13 09:10:19
- archived_atdate & time
- NULL
first 6 of 9,962 rows · your queries use all of them
solution.sql
Hints and the answer are always available. Using them counts the question as solved with help.