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