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 ShortestCity AS (
SELECT CITY, LENGTH(CITY) AS LEN,
ROW_NUMBER() OVER (ORDER BY LENGTH(CITY) ASC, CITY ASC) AS t1
FROM STATION
),
LongestCity AS (
SELECT CITY, LENGTH(CITY) AS LEN,
ROW_NUMBER() OVER (ORDER BY LENGTH(CITY) DESC, CITY ASC) AS t2
FROM STATION
)
SELECT CITY, LEN
FROM ShortestCity
WHERE t1 = 1
UNION ALL
SELECT CITY, LEN
FROM LongestCity
WHERE t2 = 1;
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 ShortestCity AS ( SELECT CITY, LENGTH(CITY) AS LEN, ROW_NUMBER() OVER (ORDER BY LENGTH(CITY) ASC, CITY ASC) AS t1 FROM STATION ), LongestCity AS ( SELECT CITY, LENGTH(CITY) AS LEN, ROW_NUMBER() OVER (ORDER BY LENGTH(CITY) DESC, CITY ASC) AS t2 FROM STATION ) SELECT CITY, LEN FROM ShortestCity WHERE t1 = 1
UNION ALL
SELECT CITY, LEN FROM LongestCity WHERE t2 = 1;