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
CITY_MAX AS (
SELECT CITY, LENGTH(CITY) AS LENGTH, 1 AS ord
FROM STATION
ORDER BY LENGTH(CITY) DESC, CITY ASC
FETCH FIRST 1 ROWS ONLY
),
CITY_MIN AS (
SELECT CITY, LENGTH(CITY) AS LENGTH, 2 AS ord
FROM STATION
ORDER BY LENGTH(CITY) ASC, CITY ASC
FETCH FIRST 1 ROWS ONLY
)
SELECT CITY, LENGTH
FROM (
SELECT CITY, LENGTH, ord FROM CITY_MAX
UNION ALL
SELECT CITY, LENGTH, ord FROM CITY_MIN
) AS t
ORDER BY ord;
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 CITY_MAX AS ( SELECT CITY, LENGTH(CITY) AS LENGTH, 1 AS ord FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ASC FETCH FIRST 1 ROWS ONLY ), CITY_MIN AS ( SELECT CITY, LENGTH(CITY) AS LENGTH, 2 AS ord FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC FETCH FIRST 1 ROWS ONLY ) SELECT CITY, LENGTH FROM ( SELECT CITY, LENGTH, ord FROM CITY_MAX UNION ALL SELECT CITY, LENGTH, ord FROM CITY_MIN ) AS t ORDER BY ord;