B<dic class="slide">
  <h1>Exercise <span class="exercisenumber"></span>: Cities in Italy</h1>
  <p>
    List all of the cities in Italy, whose population is more than 1% of Italy's population. Organize results by Name alphabetically. Do this as a single query. Do not hard code Italy's country code. (JOIN) Expected results: 
  </p>

  <pre class="expectedresults">
+--------------+-----------+--------------+-------------+
| name         | district  | population   | percentage  |
+--------------+-----------+--------------+-------------+
| Genova       | Liguria   | 6361034      | 0.0110      |
| Milano       | Lombardia | 1300977      | 0.0226      |
| Napoli       | Campania  | 1002619      | 0.0174      |
| Palermo      | Sisilia   | 683794       | 0.0119      |
| Roma         | Latium    | 2643581      | 0.0458      |
| Torino       | Piemonte  | 903705       | 0.0157      |
+--------------+-----------+--------------+-------------+
</pre>
</div>

<div class="slide">
  <h1>Exercise <span class="exercisenumber noincrement"></span> Solution</h1>
  <pre class="answer">
SELECT cities.name, district, cities.population, 
       cities.population/countries.population as percentage
FROM countries
JOIN cities ON code = country_code
WHERE countries.name = "Italy"
AND cities.population/countries.population > 0.01
ORDER BY district ASC
</pre>
</div>