asked on
ENROLL_ID STU_ID SUBJECT_CODE CLASS_NAME SESSION TERM MARKS
1 001 ENG SS1A 2018 1st 40
2 001 MATHS SS1A 2018 1st 40
3 002 ENG SS1A 2018 1st 50
4 002 MATHS SS1A 2018 1st 50
5 001 ENG SS1A 2018 2nd 45
6 001 MATHS SS1A 2018 2nd 50
7 002 ENG SS1A 2018 2nd 55
8 002 MATHS SS1A 2018 2nd 55
9 001 ENG SS1A 2018 3rd 60
10 001 MATHS SS1A 2018 3rd 70
11 002 ENG SS1A 2018 3rd 65
12 002 MATHS SS1A 2018 3rd 50
ENROLL_ID STU_ID SUBJECT_CODE CLASS_NAME SESSION 1st_TERM 2nd_Term 3rd_Term Total Average
1 001 ENG SS1A 2018 40 45 60 145 48.3
2 001 MATHS SS1A 2018 40 50 70 160 53.3
3 002 ENG SS1A 2018 50 55 65 170 56.7
4 002 MATHS SS1A 2018 50 55 50 155 51.7
ASKER
[1st_TERM],
[2nd_TERM],
[3rd_TERM],
`1st_TERM`,
`2nd_TERM`,
`3rd_TERM`,
PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.
TRUSTED BY
You've tagged this post as PHP - I would suggest you build your data model using that instead. It'll probably be a lot easier than trying to do it in mysql