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

Weather Observation Station 15

Problem
Submissions
Leaderboard
Discussions

Sort 1611 Discussions, By:

recency

Please Login in order to post a comment

  • mailmeakash2
    17 hours ago+ 0 comments

    select round(long_w,4) from station where lat_n<137.2345 order by lat_n desc limit 1

    2|
    Permalink
  • udaya91221
    20 hours ago+ 0 comments

    select rtrim(round(long_w,4),0) from station where lat_n=(SELECT MAX (LAT_N) FROM STATION WHERE LAT_N < 137.2345)

    1|
    Permalink
  • xono_18
    23 hours ago+ 0 comments
    SELECT cast(round(LONG_W,4) as decimal(20,4)) FROM STATION WHERE LAT_N IN(SELECT MAX(LAT_N) FROM STATION WHERE LAT_N<137.2345); 
    
    0|
    Permalink
  • namnmfx22541
    3 days ago+ 0 comments
    SELECT ROUND(LONG_W, 4)
        FROM STATION
            WHERE LAT_N IN 
             (SELECT MAX(LAT_N) 
                 FROM STATION 
                    WHERE LAT_N < 137.2345);
    
    0|
    Permalink
  • ranjithkumarchi1
    3 days ago+ 0 comments

    select CAST(MAX(LONG_W)AS DECIMAL (21,4)) from STATION where LAT_N IN (Select MAX(LAT_N) from Station where 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