create cursor tt(id int autoinc, name v( 10 ))

insert into tt (name) values ("саша")
insert into tt (name) values ("саша")
insert into tt (name) values ("саша")
insert into tt (name) values ("саша")

insert into tt (name) values ("петя")
insert into tt (name) values ("петя")

insert into tt (name) values ("вася")
insert into tt (name) values ("вася")
insert into tt (name) values ("вася")
insert into tt (name) values ("вася")

select count(*), name ;
	from tt ;
	group by name