create table stawka ( id integer not null, value double  not null );

insert into stawka values ( 1, 100.00 );
insert into stawka values ( 2, 200.00 );
insert into stawka values ( 3, 300.00 );
insert into stawka values ( 4, 150.00 );

create table krit ( name varchar(20) not null, val varchar(20) not null, stawka integer not null );

insert into krit values ( 'Тариф', 'C', 1 ) 
insert into krit values ( 'Тариф', 'C', 2 ) 
insert into krit values ( 'Выслуга', '>10', 2 ) 
insert into krit values ( 'Тариф', 'C', 3 ) 
insert into krit values ( 'Выслуга', '>10', 3 ) 
insert into krit values ( 'Регион', 'Север', 3 ) 
insert into krit values ( 'Тариф', 'C', 4 ) 
insert into krit values ( 'Выслуга', '>10', 4 ) 
insert into krit values ( 'Регион', 'Юг', 4 ) 

select stawka, count(1) from (
select stawka from krit where name = 'Тариф' and val = 'C'
union all
select stawka from krit where name = 'Выслуга' and val = '>10'
union all
select stawka from krit where name = 'Регион' and val = 'Север' ) s
group by stawka order by 2 desc