Query Run
SELECT SUBSTRING_INDEX(page_title, '/', 1) AS project, SUM( ( ... 1 year ago