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

Weather Observation Station 2

Problem
Submissions
Leaderboard
Discussions
Editorial

Sort 964 Discussions, By:

recency

Please Login in order to post a comment

  • ganeiu
    2 days ago+ 0 comments

    Select cast(sum(lat_n) as numeric (16,2)), cast(sum(long_w) as numeric (16,2)) from station;

    0|
    Permalink
  • abhash_singh2
    2 days ago+ 0 comments
    SELECT ROUND(SUM(LAT_N), 2), ROUND(SUM(LONG_W), 2) FROM STATION
    
    0|
    Permalink
  • scthakuri87
    3 days ago+ 0 comments

    using cte in MySQL: with cte as ( select sum(LAT_N) as lat_n ,sum(LONG_W) as long_w from STATION ) select round(cte.lat_n,2) ,round(cte.long_w,2) from cte;

    0|
    Permalink
  • myuvaraj008
    4 days ago+ 0 comments

    select round(sum(lat_n),2) , round(sum(long_w),2) from station

    0|
    Permalink
  • alibha_dash94
    1 week ago+ 1 comment

    IN Microsoft SQl SELECT CAST(SUM(LAT_N) AS DECIMAL(18,2)), CAST(SUM(LONG_W) AS DECIMAL(18,2)) FROM STATION ;

    0|
    Permalink
Load more conversations

Need Help?


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