Hackerrank – Weather Observation Station 1

9. January 2016 Pavol PidaničComments are off for this post.

Problem Statement
A description of the problem can be found on Hackerrank.

Solution
Select City, State and then order first by city ascending and then state ascending.

I created solution in:

All solutions are also available on my GitHub.

SQL

select city, state from station order by city asc, state asc;

1	select city, state from station order by city asc, state asc;