计算字符串中字符的出现次数和使用SQL的Group By

I try to count occurrences and to add group by after, but I have an errorI try to count occurrences and to add group by