1with proxy_contracts as (
2SELECT year(block_timestamp) as year
3       , count(CASE WHEN is_proxy THEN contract_address END) as proxy_contracts
4       , count(CASE WHEN NOT is_proxy THEN contract_address END) as non_proxy_contracts
5       , count(*) as total_contracts
6FROM
7  "@blt.ethereum_contracts.contract_abis"
8GROUP BY all
9ORDER BY 1, 2
10)
11select p.year, p.proxy_contracts, p.non_proxy_contracts
12       , ROUND(1.0*proxy_contracts / total_contracts, 2) as perc_proxy_contracts
13       , ROUND(1.0*non_proxy_contracts / total_contracts, 2) as perc_non_proxy_contracts
14from proxy_contracts p