Reorganized title: Calculating the total value of other columns using MySQL's Group By and Sum

Question

I have two columns like this:

Word	Amount
dog	1
dog	5
Elephant	2

I want to sum the amounts and get the result

Word	Amount
dog	6
Elephant	2

What I have tried (and failed) so far is:

SELECT word, SUM(amount) FROM `Data` GROUP BY 'word'

Answer 1

It should be accented symbol instead of single quote :

SELECT word, SUM( amount )
FROM Data
GROUP BY `word`;

Output:

word     SUM(amount)
dog           6
Elephant      2

Answer 2

Remove the single quotes around WORD. It causes column names to be converted to strings.

SELECT word, SUM(amount) 
FROM Data 
Group By word