• + 1 comment

    Actually, it doesn't matter that you use e.company_code or c.company_code. The only difference is that you only GROUP BY c.company_code, but he GROUP BY c.company_code, c.founder. Try to add c.founder in GROUP BY clause, it should work. :)