title: HackerRank Weather Observation Station 5
body: <p>I would like to know why my code isnt working. This question has been asked before here: 
  <a href="https://stackoverflow.com/questions/39129585/query-the-two-cities-in-station-with-the-shortest-and-longest-city-names">Query the two cities in STATION with the shortest and longest CITY names,</a></p>
  
  <p>and solution here:
  <a href="https://github.com/chhayac/SQL-hackerrank-problems/blob/master/basic-select.md" rel="nofollow noreferrer">https://github.com/chhayac/SQL-hackerrank-problems/blob/master/basic-select.md</a></p>
  
  <p>But both answers do not work. I have pasted the question below followed by my solution. Thanks for the help!</p>
  
  <p>Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically.</p>
  
  <p>Input Format</p>
  
  <p>The STATION table is described as follows:</p>
  
  <pre><code>Station.jpg
  </code></pre>
  
  <p>where LAT_N is the northern latitude and LONG_W is the western longitude.</p>
  
  <p>Sample Input</p>
  
  <p>Let's say that CITY only has four entries: DEF, ABC, PQRS and WXY</p>
  
  <p>Sample Output</p>
  
  <pre><code>ABC 3
  PQRS 4
  </code></pre>
  
  <p>Explanation</p>
  
  <p>When ordered alphabetically, the CITY names are listed as ABC, DEF, PQRS, and WXY, with the respective lengths  and . The longest-named city is obviously PQRS, but there are  options for shortest-named city; we choose ABC, because it comes first alphabetically.</p>
  
  <p>Note 
  You can write two separate queries to get the desired output. It need not be a single query.</p>
  
  <p>MY ANSWER:</p>
  
  <p>/<em>shortest character length sorted in alphabetical order</em>/</p>
  
  <pre><code>SELECT city, LENGTH(city) as length_char
  FROM station
  ORDER BY LENGTH(city) ASC, city ASC
  LIMIT 1;
  </code></pre>
  
  <p>/<em>longest character length sorted in alphabetical order</em>/</p>
  
  <pre><code>SELECT city, LENGTH(city) as length_char
  FROM station
  ORDER BY LENGTH(city) DESC
  LIMIT 1;
  </code></pre>