Query Run
SELECT actor_name, COUNT(DISTINCT substring(rev_timestamp, 1, 8)) as... 1 day ago
SELECT actor_name, COUNT(DISTINCT substring(rev_timestamp, 1, 8)) as... 1 week ago