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