Number of Automated Edits

Retrieving Number of Automated edits done i.e ( Edits done by the bots) , 
For that we need Revision , actor , user_group tables to get the data . 
Revision table stores the edits done in database and 
Actor table shows the edit done by whom (user or bot)  and 
to conform edit done by bot we use user_group table in which 
ug_group contains values like : 'bot', 'bureaucrat', 'sysop...

SQL

SELECT COUNT(*) AS Automated_Edits 
FROM revision -- To find the number of edits we refer Revision table 
JOIN actor ON revision.rev_actor = actor.actor_id -- Joining actor and revision table 
JOIN user_groups ON actor.actor_user = user_groups.ug_user -- Joining user_group and actor table 
WHERE user_groups.ug_group = 'bot'
  AND revision.rev_timestamp BETWEEN '20230101' AND '20240301'; -- Filtering the output in specific dates

​x
 
SELECT COUNT(*) AS Automated_Edits FROM revision -- To find the number of edits we refer Revision table JOIN actor ON revision.rev_actor = actor.actor_id -- Joining actor and revision table JOIN user_groups ON actor.actor_user = user_groups.ug_user -- Joining user_group and actor table WHERE user_groups.ug_group = 'bot'  AND revision.rev_timestamp BETWEEN '20230101' AND '20240301'; -- Filtering the output in specific dates​

SQL

Checking query status...