Adventar posted entry rate

query.sql

select
    year
    , entry_count
    , posted_url_count
    , round(100.0 * posted_url_count / entry_count, 2) as rate
from (
    select
        extract(year from date) as year
        , count(*) as entry_count
        , count(case when url != '' then 1 end) as posted_url_count
    from entries
    group by 1
) t
order by
    1
;

result.tsv

result2.svg