USE wikidatawiki_p;

​

#SELECT * FROM actor WHERE actor_name='MisterSynergy';

​

SELECT

   #SUBSTR(revision.rev_timestamp, 1, 6) AS bucket, # 4 year, 6 month, 8 day, 10 hour, 12 minute

   FLOOR(revision.rev_timestamp / 100000000) AS bucket, # 4 year, 6 month, 8 day, 10 hour, 12 minute

   COUNT(revision.rev_id) AS cnt

FROM

    revision JOIN actor_revision ON revision.rev_actor=actor_revision.actor_id

WHERE

    actor_revision.actor_user=44949

    AND revision.rev_timestamp>20200800000000

GROUP BY

    bucket;