I have a file with a large number of employees in different departments, with the department numbers recurring throught the data

I need a summary report by dept which lists total number of employees and total number of hours (another field on every record). I could write a routine to do it but I know_ there has to be a sql statement. Any ideas?

TIA
CG