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

Weather Observation Station 19

Problem
Submissions
Leaderboard
Discussions

Sort 1525 Discussions, By:

recency

Please Login in order to post a comment

  • sj00940615
    1 day ago+ 0 comments
    select round(power(power((min(lat_n) - max(lat_n)),2) + power((min(long_w) - max(long_w)),2),0.5), 4)
    from station
    
    0|
    Permalink
  • amarrathore_ak
    2 days ago+ 0 comments

    /* Enter your query here. */ SELECT ROUND(SQRT(POW(MIN(LAT_N)-MAX(LAT_N),2)+POW(MIN(LONG_W )-MAX(LONG_W),2)),4) FROM STATION;

    0|
    Permalink
  • amarrathore_ak
    2 days ago+ 0 comments

    /* Enter your query here. */ SELECT ROUND(SQRT(POW(MIN(LAT_N)-MAX(LAT_N),2)+POW(MIN(LONG_W )-MAX(LONG_W),2)),4) FROM STATION;

    0|
    Permalink
  • priyanka_bopche1
    3 days ago+ 0 comments

    Select CAST(round(sqrt(power(max(LAT_N)-min(LAT_N),2)+power(max(LONG_W)-min(LONG_W),2)),4) as numeric(12,4)) from STATION

    0|
    Permalink
  • nhipham117
    4 days ago+ 1 comment

    MySQL

    SELECT ROUND(SQRT(POWER((MIN(LAT_N) - MAX(LAT_N)),2) + POWER((MIN(LONG_W) - MAX(LONG_W)),2)),4)
    FROM STATION
    
    0|
    Permalink
Load more conversations

Need Help?


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