Weather Observation Station 2

Question Link

Query the following two values from the STATION table:

  1. The sum of all values in LAT_N rounded to a scale of 2 decimal places.

  2. The sum of all values in LONG_W rounded to a scale of 2 decimal places.

where LAT_N is the northern latitude and LONG_W is the western longitude.

Output Format

Your results must be in the form:

lat lon

where is the sum of all values in LAT_N and is the sum of all values in LONG_W. Both results must be rounded to a scale of decimal places.

SELECT 
    ROUND(SUM(lat_n),2) AS lat,
    ROUND(SUM(long_w),2) AS lon
FROM Station

Last updated