I have 2 columns like so
I want the result to be dog 6, and Elephant 2. What I have made so far (and failed) is this
SELECT word, SUM(amount) FROMGroup By 'word'
Remove the single quote around the
WORD. It causes the column name to be converted as string.
SELECT word, SUM(amount) FROM Data Group By word