title: SQL - ORDER BY not returning results
body: <p>I'm trying to solve this challenge (NOT ASKING FOR THE FINAL SOLUTION)!
  <a href="https://www.hackerrank.com/challenges/weather-observation-station-5" rel="nofollow noreferrer">Problem Link</a></p>
  
  <p>First step: I wanted to return the list of city, length(city) sorted by length to use than <code>ROWNUMBER = 1</code>.</p>
  
  <p>To select city with shortest name:</p>
  
  <p>My code is:</p>
  
  <pre><code>SELECT DISTINCT city, LENGTH(city) FROM station ORDER BY LENGTH(city) ASC;
  </code></pre>
  
  <p>I was expecting the result to be sorted by LENGTH but it is sorted by city. If I change to:</p>
  
  <pre><code>SELECT DISTINCT city, LENGTH(city) FROM station ORDER BY city DESC;
  </code></pre>
  
  <p>It is still sorted by city in ASC order.</p>
  
  <p>What am I doing wrong? Or it is a problem with the page because even <code>SELECT city FROM station ORDER by city DESC;</code> does not work.</p>
  
  <p>Thanks.</p>