In SQLite, how do you show groups with a count of zero?

Vote count:

0

In SQLite, how do you show groups with a count of zero?

i.e It looks like:

AGE RANGE: ------------ COUNT:

18 - 25------------------------ 16

26 - 30------------------------- 5

31 - 35 ------------------------ 2

But I want it to look like:

AGE RANGE: ------------ COUNT:

18 - 25------------------------ 16

26 - 30------------------------- 5

31 - 35 ------------------------ 2

36+ ---------------------------- 0

Many Thanks

Z

asked 46 secs ago

user3501798

5