SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tblCOURSE
(CourseId int, CourseTitle varchar(100),CourseCode varchar(20), CrdtHrs int)

INSERT INTO tblCOURSE
(CourseId,CourseTitle,CourseCode,CrdtHrs) VALUES
(1,'Fundamentals of Programming','INSY2022',5),
(2,'Advanced Computer Programming','INSY2031',5),
(3,'Fundamentals of Database Systems','INSY2013',5),
(4,'Introduction to Information Systems and Society','INSY2033',4),
(5,'Introduction to Information Storage & Retrieval','INSY3093',4)

CREATE TABLE tblENROLLMENT
  (EnrollId int , CourseId int, StudentID int, DateofEnrollment date, MidExResult int, ProjectResult int, FinalExResult int)

INSERT INTO tblENROLLMENT(EnrollId,CourseId,StudentID,DateofEnrollment,MidExResult,ProjectResult,FinalExResult)
VALUES
(1,1,1,'2020-01-01',20,21,50),
(2,2,2,'2020-01-01',20,27,50),
(3,3,3,'2020-01-01',20,22,50),
(4,4,4,'2020-01-01',20,20,50),
(5,5,5,'2020-01-01',20,17,50),
(6,1,6,'2020-01-01',20,10,50),
(7,2,1,'2020-01-01',20,29,50),
(8,3,1,'2020-01-01',20,28,50),
(9,4,5,'2020-01-01',20,25,50),
(10,5,1,'2020-01-01',20,50,50)

15 rows affected

CourseTitle	Number Of Students
Fundamentals of Programming	2
Advanced Computer Programming	2
Fundamentals of Database Systems	2
Introduction to Information Systems and Society	2
Introduction to Information Storage & Retrieval	2
Total	10