with ecoli_ds as (select *,
percent_rank() over(order by size_of_colony desc) 'pr'
from ecoli_data)
select id,
case
when pr <= 0.25 then 'CRITICAL'
when pr <= 0.5 then 'HIGH'
when pr <= 0.75 then 'MEDIUM'
else 'LOW'
end as 'COLONY_NAME'
from ecoli_ds
order by id
with ecoli_ds as (select *,
percent_rank() over(order by size_of_colony desc) 'pr'
from ecoli_data)
select id,
case
when pr between 0 and 0.25 then 'CRITICAL'
when pr between 0.25 and 0.5 then 'HIGH'
when pr between 0.5 and 0.75 then 'MEDIUM'
else 'LOW'
end as 'COLONY_NAME'
from ecoli_ds
order by id
with ecoli_ds as (select *,
ntile(4) over(order by size_of_colony desc) 'pr'
from ecoli_data)
select id,
case
when pr=1 then 'CRITICAL'
when pr=2 then 'HIGH'
when pr=3 then 'MEDIUM'
else 'LOW'
end as 'COLONY_NAME'
from ecoli_ds
order by id