create table #t (fio varchar ( 10 ), s int) 

insert #t values ('jons',  0 ) 
insert #t values ('иванов',  3 ) 
insert #t values ('петров',  4 ) 
insert #t values ('спдоров',  10 ) 
insert #t values ('и т.д.',  11 ) 
insert #t values ('и т.п.',  22 ) 
insert #t values ('', 25 ) 
insert #t values ('', 64 ) 
insert #t values ('', 81 ) 
insert #t values ('', 87 ) 
insert #t values ('', 89 ) 
insert #t values ('', 102 ) 
insert #t values ('', 106 ) 
insert #t values ('', 133 ) 



select range = convert(varchar,s/ 10  *  10 ) + '-' + convert(varchar,s/ 10  *  10  +  9 ), count = count( 1 ) from #t group by convert(varchar,s/ 10  *  10 ) + '-' + convert(varchar,s/ 10  *  10  +  9 ), s/ 10 
order by s/ 10 

drop table #t