Change Details

select CAST( SUBSTR(dt, 0, 4) AS int ) as year, SUM(value) from mediawiki_metrics where wiki_db = 'wikidatawiki' and metric = 'daily_edits' and snapshot = '2018-08' group by CAST( SUBSTR(dt, 0, 4) AS int ) ORDER BY year ASC LIMIT 100

select CAST( SUBSTR(dt, 0, 4) AS int ) as year, SUM(value) from wmf.mediawiki_metrics where wiki_db = 'wikidatawiki' and metric = 'daily_edits' and snapshot = '2021-08' group by CAST( SUBSTR(dt, 0, 4) AS int ) ORDER BY year ASC LIMIT 100

select CAST( SUBSTR(dt, 0, 4) AS int ) as year, SUM(value) from wmf.mediawiki_metrics where wiki_db = 'wikidatawiki' and metric = 'daily_edits' and snapshot = '201821-08' group by CAST( SUBSTR(dt, 0, 4) AS int ) ORDER BY year ASC LIMIT 100