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

Weather Observation Station 2

Sort by

recency

|

1486 Discussions

|

  • abdalrahman_dah1
     + 0 comments

    SELECT FORMAT(ROUND(SUM(LAT_N), 2), '0.##') AS Sum_Latitude, FORMAT(ROUND(SUM(LONG_W), 2), '0.##') AS Sum_Longitude FROM STATION;

  • iiroy2049
     + 0 comments

    MYSQL =

    select round(sum(LAT_N),2) , round(sum(LONG_W),2) from station

  • ramoncassilha
     + 0 comments

    SELECT CAST(ROUND(SUM(LAT_N),2) AS DECIMAL(10,2)) AS lat, CAST(ROUND(SUM(LONG_W),2) AS DECIMAL(10,2)) AS lon FROM STATION; ==================42850.04 | 47381.48 ========================

  • bwubts24305
     + 0 comments

    SELECT ROUND(SUM(LAT_N), 2) AS Sum_Latitude, ROUND(SUM(LONG_W), 2) AS Sum_Longitude FROM STATION;

  • sathishkishore31
     + 0 comments

    Query the following two values from the STATION table:

    The sum of all values in LAT_N rounded to a scale of 2 decimal places. The sum of all values in LONG_W rounded to a scale of 2 decimal places.