Im trying to get the age of each person by computing on their birthday. Now I need to group them which I already achieved. Now what I want is to count how many in group 20 and below and so forth and so on.

Here's my query

```
select case when datediff(now(), birthday) / 365.25 > 50 then '51 & over' when datediff(now(), birthday) / 365.25 > 30 then '31 - 50' when datediff(now(), birthday) / 365.25 > 19 then '20 - 30' else 'under 20' end as age_group from members

```

The result is

[![enter image description here](https://i.stack.imgur.com/d0Oh1.png)](https://i.stack.imgur.com/d0Oh1.png)

Where I tried to group it by the query below

```
select case when datediff(now(), birthday) / 365.25 > 50 then '51 & over' when datediff(now(), birthday) / 365.25 > 30 then '31 - 50' when datediff(now(), birthday) / 365.25 > 19 then '20 - 30' else 'under 20' end as age_group from members group by age_group

```

Result will be
[![enter image description here](https://i.stack.imgur.com/tBWFO.png)](https://i.stack.imgur.com/tBWFO.png)

But what I need is somethinglike this
[![enter image description here](https://i.stack.imgur.com/aHQfJ.png)](https://i.stack.imgur.com/aHQfJ.png)

\*\*NOte: Photo edited.

How do I achieved that I need to place the count result in a chart.