SELECT Subject, Semester, Count(*)
SELECT
Subject, Semester,
Count
(*)
FROM
Subject_Selection
GROUP
BY
Subject, Semester