You are viewing a single comment's thread. Return to all comments →
WITH CITY_LENGTH_1 AS ( SELECT MIN(CITY) AS city, LEN(CITY) AS city_length FROM STATION GROUP BY LEN(CITY) ) SELECT city, city_length FROM CITY_LENGTH_1 WHERE city_length IN (SELECT MIN(city_length) FROM CITY_LENGTH_1) OR city_length IN (SELECT MAX(city_length) FROM CITY_LENGTH_1) ORDER BY city_length
Seems like cookies are disabled on this browser, please enable them to open this website
An unexpected error occurred. Please try reloading the page. If problem persists, please contact support@hackerrank.com
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →