Below is my query that returns information about certain people, courses they have taken and their credits for each course. Certain people have earned more than 5.0 credits total and some have not. I need to return only those people who have a total of 5.0 or more earned credits (CEUs). I have tried playing around with the SUM and GROUP BY statements, but have had no luck getting them to work. DECLARE @from datetime, @to datetimeSET @from = CONVERT(varchar(11), @MinDate, 1)SET @to = CONVERT(varchar(11), @Maxdate, 1)SELECT DISTINCTEducationCreditHistory.ContactID, EducationCreditHistory.CourseID, contactbase.FirstName, contactbase.LastName, Courses.CourseCode, Courses.StartDate, EdCategoryXref.Category, EdCategoryXref.CEUs, OpportunityBase.Name, Contact.ContactId AS Expr1FROM EducationCreditHistory INNER JOIN contactbase ON EducationCreditHistory.ContactID = contactbase.ContactId INNER JOIN Courses ON EducationCreditHistory.CourseID = Courses.CourseID INNER JOIN EdCategoryXref ON EducationCreditHistory.TransactionID = EdCategoryXref.TransactionID INNER JOIN OpportunityBase ON EducationCreditHistory.ContactID = OpportunityBase.ContactId INNER JOIN Contact ON contactbase.ContactId = Contact.ContactId WHERE (CONVERT(varchar(11), Courses.StartDate, 1) >= @from) AND (CONVERT(varchar(11), Courses.StartDate, 1) <= @to) AND (OpportunityBase.Name = N'AAAFEE05 - CE REGISTRY FEE') ORDER BY contactbase.LastName, Courses.CourseCode