ActiveRecord Model Querying

Hi,
I have two table with the following structure

What does your SQL look like? I’m a bit confused as to what you mean by “effort put in on each day”

Are you just trying to get all tasks where complete_dt = a certain date?

Task.group("complete_dt").sum("effort")

Hey,
That worked. Thanks for the quick reply :slight_smile:

Regards,
Elroy