[Solved] group by count in mysql [closed]

This will give you the number of employees by country.

SELECT o.country,
       COUNT(*)
  FROM office o
    INNER JOIN employee e ON e.office_id = o.office_id
  GROUP BY o.country