Opeyemi AbdulRasheed
asked on
I Need Help on Query Syntax
Hello Experts!
I have this table - tbl_enroll:
Now the challenge: I want a SELECT QUERY to give something like:
Is that doable, please?
I have this table - tbl_enroll:
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 50Now the challenge: I want a SELECT QUERY to give something like:
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.7Is that doable, please?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much. It works.
I only had to change this:
To:
I only had to change this:
[1st_TERM],
[2nd_TERM],
[3rd_TERM],To:
`1st_TERM`,
`2nd_TERM`,
`3rd_TERM`,
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