1SELECT 
2    CONCAT(i.year, ' / ', COALESCE(c.year, i.year + 26)) AS year,
3    c.monthly_active_crypto_addresses / 1000000 AS crypto_users_millions,
4    i.num_internet_users / 1000000 AS internet_users_millions,
5    c.year AS crypto_year,
6    i.year AS internet_year
7FROM 
8    "@owid.internet.owid_internet" i
9LEFT JOIN 
10    "@adlrocha.sandbox.a16z_crypto_wallets" c
11ON 
12    c.year - 26 = i.year  -- Align 2018 in crypto with 1992 in internet (26-year offset)
13WHERE 
14    i.country = 'World'
15    AND i.year BETWEEN 1990 AND 2010
16ORDER BY 
17    year;