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 13
  5. Discussions

Weather Observation Station 13

Problem
Submissions
Leaderboard
Discussions

Sort 1103 Discussions, By:

recency

Please Login in order to post a comment

  • pavel_yakimchyk
    6 hours ago+ 0 comments
    SELECT ROUND(SUM(lat_n), 4)
    FROM station
    WHERE (lat_n > 38.7880 AND lat_n < 137.2345)
    
    0|
    Permalink
  • cosarmuhammet
    10 hours ago+ 0 comments

    SELECT SUM(LAT_N) FROM STATION

    WHERE ROUND(LAT_N,4) BETWEEN 38.7880 AND 137.2345 ;

    0|
    Permalink
  • azeemmohsin01
    2 days ago+ 0 comments

    For MySQL Workbench;

    SELECT ROUND(SUM(lat_n),4) FROM station WHERE ROUND(lat_n,4) > 38.7880 AND ROUND(lat_n,4) < 137.2345;

    0|
    Permalink
  • fadhilfarhisyi
    2 days ago+ 0 comments

    in sql server : select cast(sum(lat_n) as numeric(38,4)) from station where lat_n > 38.7880 and lat_n < 137.2345

    0|
    Permalink
  • muthubalasudhan7
    2 days ago+ 0 comments

    SELECT ROUND(SUM(LAT_N),4) FROM STATION WHERE LAT_N > 38.7880 AND LAT_N < 137.2345

    0|
    Permalink
Load more conversations

Need Help?


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