We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
WITH MinLenCity AS (
SELECT TOP 1 city, LEN(city) AS city_length
FROM station
WHERE LEN(city) = (SELECT MIN(LEN(city)) FROM station)
ORDER BY city
),
MaxLenCity AS (
SELECT TOP 1 city, LEN(city) AS city_length
FROM station
WHERE LEN(city) = (SELECT MAX(LEN(city)) FROM station)
ORDER BY city DESC
)
SELECT city, city_length FROM MinLenCity
UNION ALL
SELECT city, city_length FROM MaxLenCity;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
[for MS SQL Server]
WITH MinLenCity AS ( SELECT TOP 1 city, LEN(city) AS city_length FROM station WHERE LEN(city) = (SELECT MIN(LEN(city)) FROM station) ORDER BY city ), MaxLenCity AS ( SELECT TOP 1 city, LEN(city) AS city_length FROM station WHERE LEN(city) = (SELECT MAX(LEN(city)) FROM station) ORDER BY city DESC ) SELECT city, city_length FROM MinLenCity UNION ALL SELECT city, city_length FROM MaxLenCity;