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 CityLengths AS (
SELECT
CITY,
LEN(CITY) AS 'NameLength'
FROM
STATION
),
MinCity AS (
SELECT TOP 1
CITY,
NameLength
FROM
CityLengths
ORDER BY
NameLength ASC,
CITY ASC),
MaxCity AS (
SELECT TOP 1
CITY,
NameLength
FROM
CityLengths
ORDER BY
NameLength DESC,
CITY DESC)
SELECT * FROM MinCity
UNION ALL
SELECT * FROM MaxCity;
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 →
WITH CityLengths AS ( SELECT CITY, LEN(CITY) AS 'NameLength' FROM STATION ), MinCity AS ( SELECT TOP 1 CITY, NameLength FROM CityLengths ORDER BY NameLength ASC, CITY ASC), MaxCity AS ( SELECT TOP 1 CITY, NameLength FROM CityLengths ORDER BY NameLength DESC, CITY DESC) SELECT * FROM MinCity UNION ALL SELECT * FROM MaxCity;