12 lines
271 B
SQL
12 lines
271 B
SQL
-- Author: Rodney Shaghoulian
|
|
-- Github: github.com/RodneyShag
|
|
-- HackerRank: hackerrank.com/RodneyShag
|
|
|
|
SELECT CITY, LENGTH(CITY) FROM STATION
|
|
ORDER BY LENGTH(CITY), CITY
|
|
LIMIT 1;
|
|
|
|
SELECT CITY, LENGTH(CITY) FROM STATION
|
|
ORDER BY LENGTH(CITY) DESC, CITY
|
|
LIMIT 1;
|