title: MySQL Group By and Sum total value of other column
body: <p>I have 2 columns like this:</p>
  
  <pre class="lang-none prettyprint-override"><code>+----------+--------+
  |   word   | amount |
  +----------+--------+
  | dog      |      1 |
  | dog      |      5 |
  | elephant |      2 |
  +----------+--------+
  </code></pre>
  
  <p>I want to sum the amounts, to get the result</p>
  
  <pre class="lang-none prettyprint-override"><code>+----------+--------+
  | dog      |      6 |
  | elephant |      2 |
  +----------+--------+
  </code></pre>
  
  <p>What I have tried so far (and failed) is this:</p>
  
  <pre><code>SELECT word, SUM(amount) FROM `Data` Group By 'word'
  </code></pre>