> For the complete documentation index, see [llms.txt](https://dshub.gitbook.io/ds-hub/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dshub.gitbook.io/ds-hub/sql/sql-practice/popular-websites-for-sql-practice/hackerrank/sql-basic/weather-observation-station-13.md).

# Weather Observation Station 13

[Question Link](https://www.hackerrank.com/challenges/weather-observation-station-13/problem?isFullScreen=true)

Query the sum of *Northern Latitudes* (*LAT\_N*) from **STATION** having values greater than 38.7880 and less than 137.2345. Truncate your answer to  4 decimal places.

The **STATION** table is described as follows: \
![](https://s3.amazonaws.com/hr-challenge-images/9336/1449345840-5f0a551030-Station.jpg)

where **LAT\_N** is the northern latitude and **LONG\_W** is the western longitude.

<pre class="language-sql"><code class="lang-sql"><strong>SELECT TRUNCATE(SUM(lat_n),4) 
</strong>FROM Station
WHERE lat_n BETWEEN 38.7880 AND 137.2345
</code></pre>

{% hint style="info" %}
Keep in mind that `BETWEEN` is inclusive! For this question, it doesn’t matter if we use between or logical operator.
{% endhint %}