Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.
My Current Results
SELECT distinct s.student_number as StuNum, case when sts.testscoreid = '301' THEN sts.numscore else null end as EBRW_Total, case when sts.testscoreid = '120' THEN sts.numscore else null end as Math_Total, case when sts.testscoreid = '122' THEN sts.numscore else null end as Total_Score FROM students s LEFT JOIN StudentTestScore sts ON sts.StudentID = s.ID LEFT JOIN StudentTest st ON sts.StudentTestID = st.ID LEFT JOIN Test t ON st.TestID = t.ID WHERE s.student_number = '12345' AND t.Name = 'SAT' AND sts.NumScore > 0
StuNum,EBRW_Total,Math_Total,Total_Score 12345,,,1010 12345,,450, 12345,560,, 12345,,,,
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!