Как вывести наиболее повторяющееся значение в таблице при группировке?

create view age_hobbies as 
  select age, hobbies, count(*) cnt
  from user_hobbies
  group by age, hobbies
;

select 
	age_hobbies.age, 
	age_hobbies.hobbies
from age_hobbies
join (
	select age, max(cnt) maxcnt from age_hobbies group by age
) max_age_hobbies on 
	age_hobbies.age = max_age_hobbies.age and 
	age_hobbies.cnt = max_age_hobbies.maxcnt;

create view age_hobbies as 
  select age, hobbies, count(*) cnt
  from user_hobbies
  group by age, hobbies
;

select 
	age,
	hobbies
from (
  select 
	  age,
	  hobbies,
	  row_number() over (partition by age order by cnt desc) rnm
  from age_hobbies
) age_hobbies where rnm = 1;