title: Using JOIN and COUNT to find totals SQL
body: <p>I am super new to SQL and have been working on this query and can not seem to get it to work. I need to sum the categories (how many clients are in each country and how many clients each employee has). This is what I tried to do to get the total clients in each country:</p>
  <pre><code>COUNT(*) TotalCount,
  country.id, country.country
  FROM client
  INNER JOIN country
  ON client.country_id = country.id
  GROUP BY country.id, country.country
  </code></pre>
  <p>These are my tables:</p>
  <pre><code>CREATE TABLE employee(
      id INT AUTO_INCREMENT PRIMARY KEY,
      employee VARCHAR(40)
  );
  
  CREATE TABLE country (
      id INT AUTO_INCREMENT PRIMARY KEY,
      country VARCHAR(40)
  );
  
  CREATE TABLE client(
      id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
      name VARCHAR(40),
      email VARCHAR(40),
      sold BOOLEAN,
      date VARCHAR(40),
      email_type_id INT,
      employee_id INT,
      country_id INT,
  
      FOREIGN KEY(email_type_id) REFERENCES email_type(id),
      FOREIGN KEY(employee_id) REFERENCES employee(id),
      FOREIGN KEY(country_id) REFERENCES country(id)
  );
  </code></pre>
  <p>Thank you so much!</p>