select B.country
from
(
select A.country, A.bin_range, count(*) as cnt
from
(
select country,
case
when networth < 10 then '0-10'
when networth < 20 then '10-20'
when networth < 30 then '20-30'
when networth < 40 then '30-40'
when networth < 50 then '40-50'
when networth < 60 then '50-60'
when networth < 70 then '60-70'
when networth < 80 then '70-80'
when networth < 90 then '80-90'
when networth < 100 then '90-100'
when networth < 110 then '100-110'
when networth < 120 then '110-120'
when networth < 130 then '120-130'
when networth < 140 then '130-140'
when networth < 150 then '140-150'
when networth < 160 then '150-160'
when networth < 170 then '160-170'
when networth < 180 then '170-180'
when networth < 190 then '180-190'
when networth < 200 then '190-200'
end as bin_range
from billionaires_2021
) as A
group by A.country, A.bin_range
order by A.country asc, A.bin_range asc
) as B
group by B.country
order by B.country;select B.country
from
(
select A.country, A.bin_range, count(*) as cnt
from
(
select country,
case
when networth < 10 then '0-10'
when networth < 20 then '10-20'
when networth < 30 then '20-30'
when networth < 40 then '30-40'
when networth < 50 then '40-50'
when networth < 60 then '50-60'
when networth < 70 then '60-70'
when networth < 80 then '70-80'
when networth < 90 then '80-90'
when networth < 100 then '90-100'
when networth < 110 then '100-110'
when networth < 120 then '110-120'
when networth < 130 then '120-130'
when networth < 140 then '130-140'
when networth < 150 then '140-150'
when networth < 160 then '150-160'
when networth < 170 then '160-170'
when networth < 180 then '170-180'
when networth < 190 then '180-190'
when networth < 200 then '190-200'
end as bin_range
from billionaires_2021
) as A
group by A.country, A.bin_range
order by A.country asc, A.bin_range asc
) as B
group by B.country
order by B.country;select B.country
from
(
select A.country, A.bin_range, count(*) as cnt
from
(
select country,
case
when networth < 10 then '0-10'
when networth < 20 then '10-20'
when networth < 30 then '20-30'
when networth < 40 then '30-40'
when networth < 50 then '40-50'
when networth < 60 then '50-60'
when networth < 70 then '60-70'
when networth < 80 then '70-80'
when networth < 90 then '80-90'
when networth < 100 then '90-100'
when networth < 110 then '100-110'
when networth < 120 then '110-120'
when networth < 130 then '120-130'
when networth < 140 then '130-140'
when networth < 150 then '140-150'
when networth < 160 then '150-160'
when networth < 170 then '160-170'
when networth < 180 then '170-180'
when networth < 190 then '180-190'
when networth < 200 then '190-200'
end as bin_range
from billionaires_2021
) as A
group by A.country, A.bin_range
order by A.country asc, A.bin_range asc
) as B
group by B.country
order by B.country;select B.country
from
(
select A.country, A.bin_range, count(*) as cnt
from
(
select country,
case
when networth < 10 then '0-10'
when networth < 20 then '10-20'
when networth < 30 then '20-30'
when networth < 40 then '30-40'
when networth < 50 then '40-50'
when networth < 60 then '50-60'
when networth < 70 then '60-70'
when networth < 80 then '70-80'
when networth < 90 then '80-90'
when networth < 100 then '90-100'
when networth < 110 then '100-110'
when networth < 120 then '110-120'
when networth < 130 then '120-130'
when networth < 140 then '130-140'
when networth < 150 then '140-150'
when networth < 160 then '150-160'
when networth < 170 then '160-170'
when networth < 180 then '170-180'
when networth < 190 then '180-190'
when networth < 200 then '190-200'
end as bin_range
from billionaires_2021
) as A
group by A.country, A.bin_range
order by A.country asc, A.bin_range asc
) as B
group by B.country
order by B.country;select B.country
from
(
select A.country, A.bin_range, count(*) as cnt
from
(
select country,
case
when networth < 10 then '0-10'
when networth < 20 then '10-20'
when networth < 30 then '20-30'
when networth < 40 then '30-40'
when networth < 50 then '40-50'
when networth < 60 then '50-60'
when networth < 70 then '60-70'
when networth < 80 then '70-80'
when networth < 90 then '80-90'
when networth < 100 then '90-100'
when networth < 110 then '100-110'
when networth < 120 then '110-120'
when networth < 130 then '120-130'
when networth < 140 then '130-140'
when networth < 150 then '140-150'
when networth < 160 then '150-160'
when networth < 170 then '160-170'
when networth < 180 then '170-180'
when networth < 190 then '180-190'
when networth < 200 then '190-200'
end as bin_range
from billionaires_2021
) as A
group by A.country, A.bin_range
order by A.country asc, A.bin_range asc
) as B
group by B.country
order by B.country;