Group by with like in sql select query

If you have a table which has values like a,b,c and you want to get count like start from a,b or c columns value then you can use query following way.

Select Left( name, 1) AS NameCaps, Count(name) as Name From Table_my GROUP BY Left( name, 1)