This is what i have currently
| admno | Name | engscore | engrade | Class | sciencescore | sciencegrade | sstscore | sstgrade | mathsscore | mathsgrade | expressed |
|---|
| 19-07561 |
MAKUMBI TARIQ AZIZI |
70 |
3 |
P1 |
68 |
4 |
70 |
3 |
60 |
5 |
END TERM 1 2019 |
| 19-07561 |
MAKUMBI TARIQ AZIZI |
74 |
3 |
P1 |
60 |
5 |
67 |
4 |
88 |
2 |
END TERM 3 2019 |
| 19-07561 |
MAKUMBI TARIQ AZIZI |
52 |
7 |
P1 |
61 |
5 |
59 |
6 |
76 |
3 |
END TERM2 2019 |
| 19-07561 |
MAKUMBI TARIQ AZIZI |
75 |
3 |
P1 |
63 |
5 |
64 |
5 |
49 |
8 |
MID TERM 1 2019 |
| 19-07561 |
MAKUMBI TARIQ AZIZI |
52 |
7 |
P1 |
56 |
6 |
67 |
4 |
80 |
2 |
MID TERM 3 2019 |
| 19-07561 |
MAKUMBI TARIQ AZIZI |
55 |
6 |
P1 |
71 |
3 |
75 |
3 |
71 |
3 |
MIDTERM 2 2019 |
BELOW IS THE EXPECTED OUTPUT. I WANTEDTHE DATA TO BE PRESENTED LIKE THIS
| admno |
Names |
Subject |
First |
Second |
FirsAgg |
SecAgg |
DifferenceMks |
DifferenceAgg |
Categorymks |
CategoryAgg |
| 19-07561 |
MAKUMBI TARIQ AZIZI |
ENG |
70 |
74 |
3 |
3 |
4 |
0 |
IMPROVED |
CONSTANT |
| 19-07561 |
MAKUMBI TARIQ AZIZI |
SCIENCE |
68 |
60 |
4 |
5 |
-8 |
-1 |
DECLINED |
DECLINED |
Please help me with any code to execute this task easily thanks
