Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version


PostgreSQL 12.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit


create table t(person_id int, age int)
insert into t
select 21352471,    59 union all
select 22157363,    51 union all
select 22741394,    75 union all
select 22764902,    27 union all
select 22771872,    62 
5 rows affected

select concat(
       case when x=1 then 0 else (x-1)*10+1 end
       ,'-'
       ,x*10
       ) as ranges
  from generate_series(1,10) x


ranges


0-10

11-20

21-30

31-40

41-50

51-60

61-70

71-80

81-90

91-100


with data
  as (select concat(
                   case when x=1 then 0 else (x-1)*10+1 end
                   ,'-'
                   ,x*10
                  ) as ranges
             ,case when x=1 then 0 else (x-1)*10+1 end lv
             ,x*10 as hv
        from generate_series(1,10) x
      ) 
    select d.ranges as age_bracket
          ,count(t.person_id) as frequency
     from data d
left join t 
       on t.age>=d.lv
      and t.age<=d.hv
group by d.ranges 
order by 1
       


age_bracket
frequency


0-10
0

11-20
0

21-30
1

31-40
0

41-50
0

51-60
2

61-70
1

71-80
1

81-90
0

91-100
0

age_bracket	frequency
0-10	0
11-20	0
21-30	1
31-40	0
41-50	0
51-60	2
61-70	1
71-80	1
81-90	0
91-100	0