• select

    List_,

    Description,

    count(month(TimeClicked)) as MonthTimeClicked

    from clicktracking_ with (nolock)

    inner join members_ on clicktracking_.MemberID_ = Members_.MemberID_

    inner join lyrLookupCompletionStatus on lyrCompletedRecips.CompletionStatusID = lyrLookupCompletionStatus.CompletionStatusID

    group by

    List_,

    Description