We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  • HackerRank Home

    HackerRank

  • |
  • Prepare
  • Certify
  • Compete
  • Hiring developers?
  1. Prepare
  2. SQL
  3. Aggregation
  4. Weather Observation Station 2

Weather Observation Station 2

Problem
Submissions
Leaderboard
Discussions
Editorial
  1. Prepare
  2. SQL
  3. Aggregation
  4. Weather Observation Station 2
Exit Full Screen View
  • Problem
  • Submissions
  • Leaderboard
  • Discussions
  • Editorial

Query the following two values from the STATION table:

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

Input Format

The STATION table is described as follows:

Station.jpg

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.

  • Blog
  • Scoring
  • Environment
  • FAQ
  • About Us
  • Support
  • Careers
  • Terms Of Service
  • Privacy Policy