agorakit/agorakit

class GroupInsightsController extends Controller
{
    //
    public function index(Group $group)
    {
        //
        $results = \App\Discussion::selectRaw('year(created_at) year, extract(YEAR_MONTH FROM created_at) AS yearmonth, monthname(created_at) month, count(*) data')
            ->groupBy('yearmonth')
            ->orderBy('yearmonth', 'asc')
            ->where('group_id', $group->id)
            ->get();
        //
    }
    //
}