Hi Folks,
Can you please help me with the below query:
Master Data:
[TABLE="width: 198"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Username[/TD]
[TD]Subject[/TD]
[TD]Score[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]English[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]Maths[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]Physics[/TD]
[TD="align: right"]34[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]History[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]Geography[/TD]
[TD="align: right"]56[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]English[/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]Maths[/TD]
[TD="align: right"]67[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]Physics[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]History[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]English[/TD]
[TD="align: right"]67[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]Maths[/TD]
[TD="align: right"]89[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]Physics[/TD]
[TD="align: right"]65[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]History[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]Geography[/TD]
[TD="align: right"]72[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]Maths[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]Physics[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]History[/TD]
[TD="align: right"]67[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]Geography[/TD]
[TD="align: right"]45[/TD]
[/TR]
</tbody>[/TABLE]
Result Data:
[TABLE="width: 380"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Username[/TD]
[TD]History[/TD]
[TD]Physics[/TD]
[TD]Geography[/TD]
[TD]Maths[/TD]
[TD]English[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
Please help
Can you please help me with the below query:
Master Data:
[TABLE="width: 198"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Username[/TD]
[TD]Subject[/TD]
[TD]Score[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]English[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]Maths[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]Physics[/TD]
[TD="align: right"]34[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]History[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]Geography[/TD]
[TD="align: right"]56[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]English[/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]Maths[/TD]
[TD="align: right"]67[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]Physics[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]History[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]English[/TD]
[TD="align: right"]67[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]Maths[/TD]
[TD="align: right"]89[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]Physics[/TD]
[TD="align: right"]65[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]History[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]Geography[/TD]
[TD="align: right"]72[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]Maths[/TD]
[TD="align: right"]45[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]Physics[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]History[/TD]
[TD="align: right"]67[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]Geography[/TD]
[TD="align: right"]45[/TD]
[/TR]
</tbody>[/TABLE]
Result Data:
[TABLE="width: 380"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Username[/TD]
[TD]History[/TD]
[TD]Physics[/TD]
[TD]Geography[/TD]
[TD]Maths[/TD]
[TD]English[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
Please help