Finding max length of a string + which string it is in Oracle SQL
<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>