SELECT 
COUNT(std.serial_std)
FROM student std
JOIN student_by_course stc ON std.serial_std = stc.serial_std
JOIN course crs ON stc.serial_crs = crs.serial_crs
WHERE crs.serial_scy = 2
AND stc.status_stc = 'ACTIVE'
AND std.status_std = 'ACTIVE'