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.
Loading...
  1. Practice
  2. SQL
  3. Aggregation
  4. Weather Observation Station 13
  5. Discussions

Weather Observation Station 13

Sort 132 Discussions, By:

votes

  • DM
    watchitdips + 0 comments

    The question specifies truncating, not rounding the values. So, if i am using round(sum(lat_n),4,1) it should work. Here the third parameter prevents the function from rounding if it is not equal to 0.

    But why the above is not working? Can anyone suggest?

  • marinskiy + 2 comments

    Here is Oracle solution from my HackerrankPractice repository:

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

    Feel free to ask if you have any questions :)

    UPD. Solution updated, see comments for details

    • ghatak_ani + 0 comments

      select CAST(SUM(LAT_N) as Decimal(12,4)) from Station where LAT_N between 38.7880 and 137.2345;

    • koushal + 1 comment

      I would like to point out that BETWEEN is inclusive, but the question specifies boundaries that are not inclusive. A simple where with two conditions would suffice for this exercise.

      • marinskiy + 0 comments

        That is atually a good point. I updated the solution here and in repo. Thanks!

  • CA
    cvasquezr + 0 comments

    ORACLE

    SELECT ROUND(SUM(LAT_N),4) FROM STATION WHERE LAT_N BETWEEN 38.7880 AND 137.2345;

  • B4
    sahubikash4441 + 0 comments

    sql server solution : select cast(sum(lat_n) as decimal(18,4)) from station where lat_n > 38.7880 and lat_n<137.2345

  • PK
    pavankumard29 + 0 comments

    Oracle solution: select round(sum(lat_n),4) from station where lat_n>38.7880 and lat_n<137.2345;

  • J
    codemaker3395 + 4 comments

    MY SQl solution: select round(sum(lat_n),4) from station where lat_n between 38.7880 and 137.2345;

    • nodakai + 1 comment

      SQL BETWEEN is inclusive, which makes it unsuitable for this exercise

      • subhashish_pand1 + 0 comments

        so just increase it by 1 and decrease 1 from suitable ends

    • DE
      ButtahNBred + 0 comments

      Inclusivity doesn't mean you can't use BETWEEN. You just have to take that into account when defining your query.

    • MA
      Md_Abu_Sadek + 0 comments

      wrong solution. anybody can imagine a counter testcase.

    • MR
      deliam_arlen + 0 comments

      This should technically fail as the requirements were that the sum is from values greater than x and less than y and the MySQL BETWEEN is inclusive but their test case obviously doesn't cover that.

      If expr is greater than or equal to min and expr is less than or equal to max, BETWEEN returns 1, otherwise it returns 0.

      https://dev.mysql.com/doc/refman/5.5/en/comparison-operators.html#operator_between

  • MK
    mark_kuruc + 0 comments

    MySQL Solution:

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

  • dilip978 + 0 comments

    //MS SQL SOLUTION

    SELECT ROUND(CAST(SUM(LAT_N) AS DECIMAL(10,4)),4) FROM STATION WHERE LAT_N > 38.7880 AND LAT_N < 137.2345;

  • S
    s_vora + 0 comments

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

    ^MYSQL/ORACLE

  • AR
    alexr3 + 0 comments

    Here's what worked for me:

    SELECT FORMAT(SUM(LAT_N), '.####')
    FROM Station
    WHERE LAT_N > 38.7880 AND LAT_N < 137.2345

Load more conversations