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;

select CITY, length(CITY) from STATION order by length(CITY) asc, CITY asc limit 1; select CITY, length(CITY) from STATION order by length(CITY) desc, CITY asc limit 1;

SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY), CITY ASC LIMIT 1; SELECT CITY, LENGTH(CITY)FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ASC LIMIT 1;

-- 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;

-- smallest and the longest city in the table

`SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC ,CITY LIMIT 1 ) UNION ( SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY),CITY LIMIT 1 ) ;