Weather Observation Station 2
- URL : https://www.hackerrank.com/challenges/weather-observation-station-2/problem
- Query the following two values from the STATION table:
- The sum of all values in LAT_N rounded to a scale of decimal places.
- The sum of all values in LONG_W rounded to a scale of decimal places.
- MySQL, Oracle Solution
1
2
3
select name
from city
where Population > 120000 and countrycode = 'USA';