متوسط عدد التعديلات في اليوم حسب الشهر لآخر سنه

SQL

/*
SELECT COUNT(rev_id) AS edit_count, DATE(rev_timestamp) AS day
FROM revision
WHERE rev_actor IN (SELECT actor_id FROM actor WHERE actor_name LIKE 'LokasBot')
GROUP BY DATE(rev_timestamp);
*/

SELECT COUNT(rev_id) / COUNT(DISTINCT DATE(rev_timestamp)) AS avg_edit_per_day
FROM revision
WHERE rev_actor IN (SELECT actor_id FROM actor WHERE actor_name LIKE 'LokasBot')
  AND YEAR(rev_timestamp) = 2023;
    AND YEAR(rev_timestamp) = YEAR(CURRENT_DATE - INTERVAL 1 MONTH)
  AND MONTH(rev_timestamp) = MONTH(CURRENT_DATE - INTERVAL 1 MONTH);

SQL

Checking query status...