title: SQL Query (joins between tables)
body: <p>there is two tables: country , countrylanguage and the common columns are <strong><em>code</em></strong> in country table and <strong><em>countrycode</em></strong> in countrylanguage.
  how to retrieve the name of country and count of spoken language in each.
  here is what I wrote:</p>
  
  <pre><code>    select country.name , countrylanguage.language from country , countrylangauge where countrylanguage.language in (select count(language) from countrylanguage group by countrycode); 
  </code></pre>