Weather Observation Station 5

  • + 0 comments

    -- better and optimised

    -- CITIES WITH LENGTH 
    WITH MAX_MIN AS (
        SELECT MAX(LENGTH(CITY)) MAX_LEN, MIN(LENGTH(CITY)) MIN_LEN
        FROM STATION
    )
    
    SELECT CITY, LEN_CITY
    FROM (
        SELECT CITY, LENGTH(CITY) AS LEN_CITY, ROW_NUMBER() OVER (PARTITION BY LENGTH(CITY) ORDER BY CITY ) RN 
        FROM STATION 
        JOIN MAX_MIN 
        ON LENGTH(CITY) IN (MAX_LEN,MIN_LEN)
    ) T
    WHERE RN = 1;