Weather Observation Station 5 | SQL | Basic Select | HackerRank | Solution

 

Problem : https://www.hackerrank.com/challenges/weather-observation-station-5/problem

Solution :

/*

Enter your query here.

*/

(

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

) 

UNION

(

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

);