I want to save the hassle of doing many querys for the following:

I have a table like this:

```
name, age
{
    Mike, 7
    Peter, 2
    Mario, 1
    Tony, 4
    Mary, 2
    Tom, 7
    Jerry, 3
    Nick, 2
    Albert, 22
    Steven, 7
}

```

And I want the following result:

```
Results(custom_text, num)
{
    1 Year, 1
    2 Year, 3
    3 Year, 1
    4 Year, 1
    5 Year, 0
    6 Year, 0
    7 Year, 3
    8 Year, 0
    9 Year, 0
    10 Year, 0
    More than 10 Year, 1
}

```

I know how to do this but in 11 queries :( But how to simplify it?

**EDIT:**

Doing the following, I can obtain the non zero values, but I need the zeroes in the right places.

```
SELECT COUNT(*) AS AgeCount
FROM mytable
GROUP BY Age

```

How can I achieve this?
Thanks for reading.