title: SQL Join 3 tables with conditions (Max value)
body: <p>I have a question about joining 3 tables with some conditions.</p>
  <p>I have 3 tables country, region, city. All I want is to return the largest city by population of every country and exclude the cities with 100.000 population or less. The thing is every table is connected with an id that is passed to the next table. Let me elaborate:</p>
  <p>Country Table:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>iso_code</th>
  <th>name</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>IN</td>
  <td>India</td>
  </tr>
  <tr>
  <td>2</td>
  <td>US</td>
  <td>United States</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Region Table:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>country_id</th>
  <th>name</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>3</td>
  <td>1</td>
  <td>Delhi</td>
  </tr>
  <tr>
  <td>4</td>
  <td>1</td>
  <td>Manipur</td>
  </tr>
  <tr>
  <td>5</td>
  <td>2</td>
  <td>Nevada</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>City Table:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>region_id</th>
  <th>name</th>
  <th>population</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>6</td>
  <td>3</td>
  <td>New Delhi</td>
  <td>320.000</td>
  </tr>
  <tr>
  <td>7</td>
  <td>3</td>
  <td>Delhi</td>
  <td>10.000.000</td>
  </tr>
  <tr>
  <td>8</td>
  <td>4</td>
  <td>Imphal</td>
  <td>220.000</td>
  </tr>
  <tr>
  <td>9</td>
  <td>5</td>
  <td>Las Vegas</td>
  <td>624.000</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>The output should look like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Country</th>
  <th>City</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>India</td>
  <td>Delhi</td>
  </tr>
  <tr>
  <td>United States</td>
  <td>Las Vegas</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I have done so much research but I can't seem to find a solution.
  Thank you in advance.</p>