Initially the query CU_BAR_CM_00026 was created to count the enrollment for the students who has taken CSTM 120 class previously. However, the query could not pick up some of students who has taken FSPM 121 class as a first time and received 'R, W, or WU'. Therefore, those students need to retake the class.
We had to create a new query because the entire logic needs to produce in different fashion.
Patrick,
I think I understand why we are missing students. Students who take the summer immersion program course FSPM 0121 have to be counted as if they had taken CSTM 0120, as this is the immersion equivalent of CSTM 0120.. When you search for repeaters, please include these students. I hope you can easily modify the query to include this group. I suspect the students Jonathan identified may be in this group.
Thank you.
Warren