7--SELECT com104,g2name,count(*) as cnt FROM `gyousyu_strkey` WHERE `com104` LIKE '非鉄金属' group by com104,g2name order by count(*) desc

view|check|strkey