SQL
x
SELECT CONCAT(LEFT(log_timestamp, 4), '-', SUBSTR(log_timestamp, 5, 2)) AS 'yyyymm',
COUNT(*) AS 'total deletions'
FROM logging
WHERE log_type = 'delete' AND log_action IN ('delete', 'delete_redir', 'delete_redir2')
GROUP BY LEFT(log_timestamp, 6);
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.