Weather Observation Station 5 in SQL | HackerRank Solution
Sample Output ABC 3 PQRS 4 Explanation When ordered alphabetically, the CITY names are listed as ABC, DEF, PQRS, and WXY, with lengths 3, 3, 4 and 3. The longest name is PQRS, but there are 3 options for shortest named city. Choose ABC, because it comes first alphabetically. Note You can write two separate queries to get the desired output.