Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
select STUDENT_NUMBER as "StuNum", max(CMTSCIENCE) AS "Grade 8 CMT Science", max(SATTOTAL) AS "Grade 8 CMT Science" FROM ( select students.student_number AS STUDENT_NUMBER, CASE WHEN UPPER(Test.Name) = 'CMT' AND StudentTest.GRADE_LEVEL = '8' AND TestScore.NAME = 'Science Scale Score' THEN StudentTestScore.numscore ELSE NULL END AS CMTSCIENCE,--"Grade 8 CMT Science" CASE WHEN UPPER(Test.Name) = 'SAT' AND TestScore.NAME = 'Total Score' THEN StudentTestScore.numscore ELSE NULL END AS SATTOTAL,--"Latest SAT Total" StudentTest.TEST_DATE from students LEFT JOIN StudentTestScore ON StudentTestScore.StudentID = Students.ID LEFT JOIN StudentTest ON StudentTestScore.StudentTestID = StudentTest.ID LEFT JOIN Test ON StudentTest.TestID = Test.ID LEFT JOIN TestScore ON StudentTestScore.TestScoreID = TestScore.ID WHERE StudentTestScore.NumScore > 0 AND Students.STUDENT_NUMBER IN ('3023484','3010864') ) WHERE CMTSCIENCE > 0 OR SATTOTAL > 0 group by STUDENT_NUMBER order by STUDENT_NUMBER
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.