Baselight
WITH internet_adoption_by_region AS (
  SELECT * FROM (VALUES
    ('North America', 55, 70, 10),
    ('Europe', 60, 65, 8),
    ('Asia-Pacific', 75, 80, 5),
    ('South America', 40, 50, 20),
    ('Africa', 25, 30, 35),
    ('Middle East', 50, 60, 15)
  ) AS t(region, percent_5g, percent_fiber, percent_satellite)
)

SELECT 
  region,
  percent_5g AS "5G (%)",
  percent_fiber AS "Fiber (%)",
  percent_satellite AS "Satellite (%)"
FROM internet_adoption_by_region
ORDER BY region;
region5G (%)Fiber (%)Satellite (%)
Africa253035
Asia-Pacific75805
Europe60658
Middle East506015
North America557010
South America405020

Share link

Anyone who has the link will be able to view this.