title: Spaces in Concat function in SQL
body: <p>I'm attempting the following problem: </p>
  
  <p><em>The capital of Mexico is Mexico City. Show all the countries where the capital has the country together with the word "City".
  Find the country where the capital is the country plus "City".</em></p>
  
  <p>And I was wondering why this query is correct: </p>
  
  <pre><code>SELECT name
  FROM world
  WHERE capital = CONCAT (name, ' city');
  </code></pre>
  
  <p>And yet this one isn't: </p>
  
  <pre><code>SELECT name
  FROM world
  WHERE capital = CONCAT (name, 'city');
  </code></pre>
  
  <p>Why does this instance of the <code>CONCAT</code> function require a space before 'city'? </p>