Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
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
|oracle query help||18||78|
|Count UNIQUE results in a field from an MS Access database||6||45|
|Oracle - How to analyze data using DATE COLUMN?||7||60|
|Access 2003 form, automatically input query parameter from list||5||31|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!