I didn't design the database, but unfortunately for whatever reason that is causing the headache here (at least for me) is that they use two identifiers! SN (student number)...

so if I union it separates the correct values in two rows....so how to sum the rows into one and display only one?

[p][/p]

DECLARE @ID INT = 4043300

SELECT

COUNT(CASE WHEN CRS.U1...

Got it thanks so much!!