Sum and distinct in acces SQL
<p>I already made a query that this was it result :</p>

<pre><code>7  |  3
8  |  4
8  |  2
8  |  1
10 |  3
12 |  4
12 |  1
13 |  3
</code></pre>

<p>I need new query that take this result and return this :</p>

<pre><code>7  |  3
8  |  **7**
10 |  3
12 |  **5**
13 |  3
</code></pre>

<p>In the left column I need that evry number will appears only once,
and in the right column sum the numbers according to the value in the left column as I showed before.</p>

<p>how to do it?</p>