select yearavailable,allCount,yearavailable*100/allCount from
(select count(*) as yearavailable from event where year is not null),
(select count(*) as allCount from event)
2021-05-10: 89% of event records have a year property that is not null 2023-01-01: 70%
1242839 1759954 70
select yearavailable,allCount,yearavailable*100/allCount from
(select count(*) as yearavailable from event where year is not null),
(select count(*) as allCount from event)
2021-05-10: 89% of event records have a year property that is not null 2023-01-01: 70%
1242839 1759954 70