title: Use count and join in sql
body: <p>There are two tables having country name,top football clubs from those countries. I want to join the table and count the clubs from each country. following code doesn't work:</p>
  
  <p>-- Table names - table2017, table2018</p>
  
  <pre><code>select t.Country, COUNT(t.Country) as '2017 Countries',
         COUNT(a.Country) as '2018 countries'
  from table2017 as t
  Join table2018 as a
  on a.Country = t.Country
  group by t.Country
  </code></pre>
  
  <p>o/p </p>
  
  <pre><code>Country 2017 Countries  2018 countries
  England       64             64
  France        1               1
  Germany       9               9
  Italy        25               25
  Spain         9               9
  </code></pre>
  
  <p>expected answer :</p>
  
  <pre><code>Country 2017 Countries  2018 countries
  England       8              8
  France        1              1
  Germany       3              3
  Italy         5              5
  Spain         3              3
  </code></pre>
  
  <p>What am i doing wrong?</p>