Workdocumentation 2021-05-10

From BITPlan cr Wiki
Revision as of 08:19, 10 May 2021 by Wf (talk | contribs) (Created page with "= PTP Event Corpus = == Year availability == <source lang='sql'> select yearavailable,allCount,yearavailable*100/allCount from (select count(*) as yearavailable from event wh...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

PTP Event Corpus

Year availability

select yearavailable,allCount,yearavailable*100/allCount from 
(select count(*) as yearavailable from event where year is not null), 
(select count(*) as allCount from event)