SQL Server 2017

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

CREATE TABLE Participants (
  ParticipantID INT,
  ParticipantLastName VARCHAR(20),
  ParticipantFirstName VARCHAR(20)
);
INSERT INTO Participants VALUES (1, 'smith', 'john');
INSERT INTO Participants VALUES (2, 'jackson', 'andrew');
INSERT INTO Participants VALUES (3, 'mayfield', 'baker');

Create Table Programs (
  ProgramID INT,
  ProgramTitle VARCHAR(255),
  EngagePoints INT,
  ProgramDate DATE
);
INSERT INTO Programs VALUES (100, 'program1', 2, '2019-10-21');
INSERT INTO Programs VALUES (200, 'program2', 3, '2020-1-2');
INSERT INTO Programs VALUES (300, 'program3', 1, '2020-2-6');

Create Table ParticipantProgramDetails (
  ParticipantID INT,
  ProgramID INT,
  ProgramDate DATE
);
INSERT INTO ParticipantProgramDetails VALUES (1, 100, '2019-10-21');
INSERT INTO ParticipantProgramDetails VALUES (2, 100, '2019-10-21');
INSERT INTO ParticipantProgramDetails VALUES (2, 200, '2020-1-2');
INSERT INTO ParticipantProgramDetails VALUES (3, 200, '2020-1-2');
INSERT INTO ParticipantProgramDetails VALUES (3, 300, '2020-2-6');

11 rows affected

ParticipantID	ParticipantFirstName	ParticipantLastName	Engage Points
1	john	smith	2
2	andrew	jackson	5
3	baker	mayfield	4