with company_year (company, years, total_laid_off,industry) as select company,year(`date`),sum(total_laid_off),industry ...

JOIN subscriptions s ON m.member_id = s.member_id ...