select a,count(*) from c group by a;
