...
- Remove duplication
- should return most recent record
- Student who passed 'ACT-MATH-2' doesn't need to correspond 'ACT-MATH-1'. Therefore, exclude 'ACT-MATH-1' from criteria.
For a query detail please see the link CU_BAR_AD_00006A_1 and CU_BAR_AD_00006B_2