Count records that start with specific letters

I have names which looks like this:

• Andrew
• Arthur
• Barry

I 开发者_如何学Cwould like to do a query which finds out how many records start with An, Ar, Ba. e.g.

• An, 1
• Ar, 1
• Ba, 1

Select COUNT(*),SUBSTRING(column_name,1,2) FROM table_name GROUP BY SUBSTRING(column_name,1,2)

SELECT SUBSTRING(name, 1, 2), COUNT(*) AS "Count"
FROM mytable
GROUP BY SUBSTRING(name, 1, 2)