I have SQL syntax with CASE condition based on birth and gender. Below is the sample query that I use

```

SELECT 
  Age,
  SUM(gender = 'M') M,
  SUM(gender = 'F') F,
  COUNT(*) TotalPerson 
FROM
  (SELECT 
    CASE
      WHEN FLOOR(DATEDIFF(CURDATE(), birdth) / 365)  60 THEN '60 Above' 
    END Age,
    gender 
  FROM
    society) ageList 
GROUP BY Age 

```

the result become like this:

```

Age         | M     | F     | TotalPerson
--------------------------------
19 - 25     | 1     | 0     | 1
19 - 25     | 1     | 0     | 1
26 - 45     | 1     | 2     | 3
46 - 60     | 0     | 1     | 1
60 Above    | 0     | 2     | 2

```

for full syntax here is my sqlfiddle: [<http://sqlfiddle.com/#!9/e8c12a/2>](http://sqlfiddle.com/#!9/e8c12a/2)  

but the result that I really need is the age with null value also display.

example like this:

```

Age         | M     | F     | TotalPerson
--------------------------------
0 - 5       | 0     | 0     | 0
6 - 10      | 0     | 0     | 0
11 - 18     | 0     | 0     | 0
19 - 25     | 1     | 0     | 1
19 - 25     | 1     | 0     | 1
26 - 45     | 1     | 2     | 3
46 - 60     | 0     | 1     | 1
60 Above    | 0     | 2     | 2

```