table-1: student
id_admission | student_name |
---|---|
101 | noman |
102 | musfik |
103 | tousif |
table-2: result
id_admission | average | exam_name |
---|---|---|
101 | 85.20 | 1st exam |
102 | 65.24 | 1st exam |
103 | 65.24 | 1st exam |
101 | 55.20 | 2nd exam |
102 | 65.24 | 2nd exam |
103 | 65.24 | 2nd exam |
101 | 75.20 | 3rd exam |
102 | 65.24 | 3rd exam |
103 | 65.24 | 3rd exam |
now I want to display in report:
id_admission | student_name | 1st exam | 2nd exam | 3rd exam | g_average |
---|---|---|---|---|---|
101 | noman | 85.20 | 55.20 | 75.20 | 71.76 |
102 | musfik | 65.20 | 65.20 | 65.20 | 65.20 |
103 | tousif | 85.20 | 55.20 | 75.20 | 71.76 |