title: Using SQL Aliases on a sample database (world) does return 0
body: <p>I'm learning SQL commands from w3schools.
  Using MySQL workbench 8, with the world sample database.</p>
  
  <p>This is how the DB looks. (first entry so you get the idea)</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>ID NAME CountryCode District Population
  
  1 Kabul AFG Kabol 1780000</code></pre>
  </div>
  </div>
  </p>
  
  <p>And I'm using this</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>SELECT Name, CountryCode + District AS Total
  FROM world.city;</code></pre>
  </div>
  </div>
  </p>
  
  <p>And the output is</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>Kabul 0</code></pre>
  </div>
  </div>
  </p>
  
  <p>and I don't get why. Is w3schools obsolete and things changed? </p>