How many courses are there in Computer Science?
SELECT COUNT ( * )  FROM Courses AS T1 JOIN Subjects AS T2 ON T1.subject_id   =   T2.subject_id WHERE T2.subject_name  =  "Computer Science"
counting courses in Computer Science refers to COUNT(*) WHERE subject_name = 'Computer Science'; joining Courses and Subjects tables on subject_id to filter courses by subject.