1. select price, dense_rank()over(order by type desc) as rnk
from (select price,count(*) as type from pc where code >=1 group by price) x


2. select price, count(*) from pc group by price

select price, dense_rank()over(order by type desc) as rnk
from (select price,count(*) as type from pc where code >=1 group by price) x

union
select price, count(*) from pc group by price

select 
  price,
  count(*) as count,
  sum( case when code >=1 then 1 else 0 end ) as count_case
from
  pc
group by
  price