How do you check the total number of people in the 0-5 age group, and if you do not have any children with a certain age, please report 0;
select idade, count(*) as qtd from pessoa group by idade order by idade
example of the current problem
+-----------+--------+
| idade | qtd |
+-----------+--------+
| 0 | 3 |
+-----------+--------+
| 3 | 7 |
+-----------+--------+
| 5 | 11 |
+-----------+--------+
Example of how I need the data
+-----------+--------+
| idade | qtd |
+-----------+--------+
| 0 | 3 |
+-----------+--------+
| 1 | 0 |
+-----------+--------+
| 2 | 0 |
+-----------+--------+
| 3 | 7 |
+-----------+--------+
| 4 | 0 |
+-----------+--------+
| 5 | 11 |
+-----------+--------+