select sum(x), y from mytable group by y

>if I have the following cursor and I want a total of each amount belonging to an item how would I go about writing an sql statement for that.
>
>

>x        y
>2        bells
>5        tables
>3        bells
>4        glasses
>

>
>I need the result to show up as:
>
>

>x        y
>5        bells
>4        glasses
>5        tables
>

>
>Thanks
>Nick Patel