Warm-up. Practice the most basic aggregate — counting rows in a table.
Return the total number of departments at the company in a single row with a single column named `department_count`. Table: `ci_departments`.
| Column | Type | Key |
|---|---|---|
| id | INT | PK |
| name | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
COUNT(*) is your friend.
Alias the output column with AS department_count.