在INNER JOIN中使用COUNT删除MySQL并不删除所有记录

I'm trying to delete records from a table if there are more than 15 from the same company (as in, if there are more than 15 records from a company, all of that companies records are deleted).I'm trying to delete records from a table if th