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 50
Now 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.7
Is that doable, please?
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.