SELECT actor_name,
SUM(rev_timestamp LIKE '202404%') AS '2024-04',
... |
3 months ago |
SELECT actor_name,
SUM(rev_timestamp LIKE '202404%') AS '2024-04',
... |
3 months ago |
SELECT COUNT(*), actor_name
FROM recentchanges -- last 30 days
JOIN... |
3 months ago |