# Implementing Group By and Sum

**URL:** <https://www.ruby-forum.com/t/implementing-group-by-and-sum/147771>\
**Category:** Rails\
**Created:** [September 5, 2008, 9:00am UTC](https://www.ruby-forum.com/t/implementing-group-by-and-sum/147771 "2008-09-05T09:00:42Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rails\_Novice](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/9de0a6/32.png) [@Rails\_Novice](https://www.ruby-forum.com/u/Rails_Novice)\
**Post date:** [September 5, 2008, 9:00am UTC](https://www.ruby-forum.com/t/implementing-group-by-and-sum/147771/1 "2008-09-05T09:00:42Z")

</div>

I want to perfom the sql query,  
SELECT employee\_id, sum(period) FROM activity\_charts group by  
employee\_id

So far, I was able to do SELECT employee\_id, period FROM  
activity\_charts group by employee\_id  
My report\_controller.rb is  
class ReportController \< ApplicationController  
def index  
@activities = ActivityChart.find(:all, :select =\>  
‘employee\_id,period’, :group =\> “employee\_id”)

end  
end

and the index.html.erb is

# Total Hours Worked
\<% @activities.each do |c| %\> \<% end %\>

| Employee | Minutes |
| --- | --- |
| \<%=h c.employee.first\_name %\>&nbsp;\<%=h c.employee.last\_name %\> | \<%=h c.period %\> |

How to include sum(period)?