Reeza is right, there are few problems with your IFstatement.
For example, you are evaluating string '13120601' three times:
- in the very first IF, in conjunction with fice and academic_year,
- then few ELSE IFs later - just '13120601';
- and in the next line - first six characters of it - '131206' and fice='00200200'.
It would really be helpful to know what question are you trying to answer? Do you need to know three things - first major was STEM-H, second major was STEM-H, any of the majors was STEM-H? Or just one - any of the majors was STEM-H?
... View more