SQL SUM to control DataList item display

ASP.NET, VB, MS SQL Server

I have a DataList that displays available training sessions to our clients. Each training session is made up of 5 different modules. Each module has a limit of 12 attendees, for a potential 60 attendees for a particular training session.  Once we reach the limit of 60 attendees, we want the particular training session to NOT appear in the DataList.  The other consideration is an expiration date for each training session, which is working fine. I only mention it because it is part of the code I have submitted below.

I have three SQL tables: one for the training location information (mutliple locations), one for the actual training sessions, and another for attendee/registrant information.

When a person clicks on the training session listed in the DataList, it brings them to a detailed page where they can select the individual training modules for that training session. When the person registers, a value of either '0' (not selected) or '1' (selected) is inserted for the particular training modules in the registrant database table. In addition, the training session's sessionID is inserted into a table column as well.

What I'm trying to do:
When the page loads, I want the DataList to SUM the 5 different modules per sessionID saved in the registrant database (which may be Null if nobody has registered for any modules within a training session). If the SUM of all 5 modules associated with the same sessionID is equal or greater than 60, don't display the training session.

Code below. Note the variables productID, trainingID and expDate are select parameters.

Thank you for any assistance or insight - I need the help and am not sure this approach is the best one.

1:
2:
3:
4:
5:
6:
7:

SELECT ts.productID, ts.trainingCatID, ts.sessionStartDate, ts.officeID, ts.sessionID,  ts.sessionEndDate, tl.officeCity, tl.OfficeState, isNull(SUM(tr.module1), 0) + isNull(SUM(tr.module2), 0) + isNull(SUM(tr.module3), 0) +isNull(SUM(tr.module4), 0) + isNull(SUM(tr.module5), 0) As WeekTotal
 
FROM TrainingLocations tl, TrainingSessions ts LEFT JOIN TrainingRegistrants tr ON ts.sessionID = tr.sessionID
 
WHERE (ts.productid = @productID AND ts.trainingID = @trainingID AND ts.officeID = tl.officeID AND expDate > @expDate AND WeekTotal < 60)
 
GROUP BY ts.productID, ts.sessionID, ts.trainingCatID, ts.sessionStartDate, ts.sessionEndDate, ts.officeID, tl.officeCity, tl.officeState, tr.module1, tr.module2, tr.module3, tr.module4, tr.module5