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;