title: Finding max length of a string + which string it is in Oracle SQL
body: <p>This for HackerRank Weather Observation 5 problem on databases (<a href="https://www.hackerrank.com/challenges/weather-observation-station-5" rel="nofollow">https://www.hackerrank.com/challenges/weather-observation-station-5</a>). How would I solve this?</p>
  
  <blockquote>
    <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>
  </blockquote>
  
  <p>This is what I have so far</p>
  
  <pre><code>SELECT CITY, MAX LENGTH(CITY) FROM STATION;
  </code></pre>
  
  <p>But it obviously doesn't work.</p>