Do you have a table of students with one record for each student? the fk_Student_ID field suggests that you do so I will assume that is the case here.
Students::pk_Student_ID = Assessment::fk_Student_ID
If you have not already done so, define sTotalScore as a summary field computing the total of score in the Assessment table.
On a layout based on Students, set up a list view layout
put pk_Student_ID in column 1, Full_Name in Column 2. (Full_Name is an unnecessary field in the Assessment table)
For column 3, add a one row portal to Assessment. Specify this portal filter:
Assessment::Subjects = "PHE"
Select sTotalScore as the sole field in this one row portal.
Duplicate this portal for column 4, but open portal setup and change the filter expression to be:
Assessment::Subjects = "Maths"
For column 5, place Assessments::sTotalScore on the layout.
Perfectly answered as always.
Thanks Phil and God bless you