7--SELECT com104,g2name,count(*) as cnt FROM `gyousyu_strkey` WHERE `com104` LIKE '冠婚葬祭' group by com104,g2name order by count(*) desc

view|check|strkey

com104g2namecnt
冠婚葬祭ブライダル・結婚式場266
冠婚葬祭葬祭業247
冠婚葬祭寺院用具75
冠婚葬祭墓石53
冠婚葬祭結婚相談24
冠婚葬祭仏壇・仏具・神具18
冠婚葬祭霊園17