Payroll Company Totals Query

Company Totals:

select def_id,sum(def_value) from prtempdefhst f 
where trx_date between '1/1/6' and '12/31/6'
group by def_id