SELECT
CONCAT(i.year, ' / ', COALESCE(c.year, i.year + 26)) AS year,
c.monthly_active_crypto_addresses / 1000000 AS crypto_users_millions,
i.num_internet_users / 1000000 AS internet_users_millions,
c.year AS crypto_year,
i.year AS internet_year
FROM
"@owid.internet.owid_internet" i
LEFT JOIN
"@adlrocha.sandbox.a16z_crypto_wallets" c
ON
c.year - 26 = i.year -- Align 2018 in crypto with 1992 in internet (26-year offset)
WHERE
i.country = 'World'
AND i.year BETWEEN 1990 AND 2010
ORDER BY
year;