Please see attached screen shot of current database table [employeeHours]
I need to write a query, or set of queries that will do the following.
Select a particular office using officeid, in the case of the screen shot it's "Smithtown".
The take each empid and add up the values in the columns f,a,s,v,o for each empid.
So I need to take all rows for empid [employee] 107 and add up f,a,s,v,o
Then all rows for employee 111 and add up f,a,s,v,o
And so on for each empid.
I'm not sure exactly how to do that. I am using a scripting language (perl) to pull these results so I can do some manipulation or multiple queries if need be. it doesn't HAVE To be all in one query but it's fine if it is.