Loading...Loading chart...
1WITH internet_adoption_by_region AS (
2 SELECT * FROM (VALUES
3 ('North America', 55, 70, 10),
4 ('Europe', 60, 65, 8),
5 ('Asia-Pacific', 75, 80, 5),
6 ('South America', 40, 50, 20),
7 ('Africa', 25, 30, 35),
8 ('Middle East', 50, 60, 15)
9 ) AS t(region, percent_5g, percent_fiber, percent_satellite)
10)
11
12SELECT
13 region,
14 percent_5g AS "5G (%)",
15 percent_fiber AS "Fiber (%)",
16 percent_satellite AS "Satellite (%)"
17FROM internet_adoption_by_region
18ORDER BY region;
19