Sum Values for Multiple Distinct Results within SQL Select query

Question

I have the following data set:

Worker	Hours
Johnny	8
Johnny	7
Johnny	4
Liz	7
Liz	2
Sally	9
Sally	9
Sally	3

question from:https://stackoverflow.com/questions/65927999/sum-values-for-multiple-distinct-results-within-sql-select-query

Answer 1

Its a simple group by :

select Worker , sum(Hours) hours
from tablename
group by worker