By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table browser_user_share(
browser varchar(25),
share decimal(5,2));
insert into browser_user_share values
('chrome',55),
('Mozila FF',17),
('MS Edge',12),
('Safari',15),
('duck duck go',0.5);
/* Then result should be Chrome, Mozila and Safari */
5 rows affected
select * from browser_user_share;
| browser | share |
|---|---|
| chrome | 55.00 |
| Mozila FF | 17.00 |
| MS Edge | 12.00 |
| Safari | 15.00 |
| duck duck go | 0.50 |
with shares as
( select browser, share,
sum(share) over (order by share desc) sum_shares
from browser_user_share) ,
over80 as
( select max(share) s80
from shares
where sum_shares >= 80 )
select browser, share, sum_shares
from shares,
over80
where share >= over80.s80
| browser | share | sum_shares |
|---|---|---|
| chrome | 55.00 | 55.00 |
| Mozila FF | 17.00 | 72.00 |
| Safari | 15.00 | 87.00 |