How to Manage Many_to_Many Relationship in SQL

Question

I want to store a student result on database, the table has the following attributes:- result_id, stu_num, subject, session, term, test_score and exam_score

So that i can print the result in form of html table
With the following syntx
Name | Number | subject1 test score & exam score | subject2 test score & exam score |

Answer 1

Thank you, i used your suggestion and it solve the issue

Answer 2

Please tag SQL and avoid writing code/query in the thread tags

https://code.sololearn.com/W3uiji9X28C1/?ref=app

Answer 3

How many tables do you have? Only one? If so, your database has not a good structure. I think you should have at least 2 tables. If I understand the question correctly.