public partial class faculty_marks_distribution : System.Web.UI.Page ...

"WHERE c.course_ID NOT IN (SELECT pc.course_id FROM previous_courses pc WHERE pc.student_id = @StudentId) " + "AND c.semester <= @Semester " + "AND NOT EXISTS (SELECT 1 FROM courses pre WHERE ...