Query select distinct(grouping) as g,count(*) as c from synonyms group by grouping having c>1 order by grouping; failed