-1

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
  • 1
    When you clicked to create this post the button said "Ask Question". But "I want" or "I need" is not a question, or a problem statement. And "how to" is a bit too vague. This site is not a free write-my-code, design-my-solution or do-my-thinking service. We'll _help_ you with your attempt to solve your problem / implement your requirement. What research have you done? What code have you tried? What exact issue(s) are you facing? Please read [ask] for further guidance on how to ask a useful question. As you're new, please also take the [tour] to learn about how stackoverflow works. Thanks. – ADyson Aug 22 '23 at 12:39

0 Answers0