Query Run
SET @last_year = DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 YEAR),... 3 months ago
SET @last_year = DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 YEAR),... 3 months ago
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