max 값 가지고 있는 아이디 구하기

select max(aa.행복_count) max_행복, aa.테마_id, aa.장소_id

from 테마별_장소들 aa,

(

select 장소_id from 테마별_장소들 

group by 장소_id, 테마_id order by max(행복_count) desc 

) bb

where aa.장소_id = bb.장소_id

group by aa.테마_id

order by max(aa.행복_count) desc;