Query Run
SELECT LEFT(rev_timestamp,4) AS iyear, actor_name, COUNT(*) As... 1 year ago
SELECT LEFT(rev_timestamp,4) AS iyear, actor_name, COUNT(*) As... 1 year ago