Code: Select all
SELECT categories.name, color, COUNT(tasks.id) as num_tasks
FROM categories
LEFT JOIN tasks ON tasks.category_id = categories.id
GROUP BY categories.idCode: Select all
name | color | num_tasks
=============================
Work | red | 4
Personal | green | 1
Vacation | blue | 0
Other | Orange | 3Code: Select all
SELECT categories.name, color, COUNT(tasks.id) as num_tasks
FROM categories
LEFT JOIN tasks ON tasks.category_id = categories.id
WHERE tasks.done = 0 # New line of code
GROUP BY categories.idCode: Select all
name | color | num_tasks
=============================
Work | red | 2
Personal | green | 1This is what I want:
Code: Select all
name | color | num_tasks
=============================
Work | red | 2
Personal | green | 1
Vacation | blue | 0
Other | Orange | 0