-
Notifications
You must be signed in to change notification settings - Fork 0
/
TA_Test_Scores_Specific.sql
105 lines (101 loc) · 1.21 KB
/
TA_Test_Scores_Specific.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
USE UWSDBDataStore;
GO
USE UWSDBDataStore;
SELECT
--s1.student_name_lowc,
--s1.student_no,
t.system_key,
t.test_type,
MAX(t.test_score) AS 'High Score'
FROM sec.APPLHISTTestScores t
join sec.student_1 s1
ON s1.system_key = t.system_key
WHERE s1.student_no IN
(
1673140,
1550989,
1870547,
1622761,
1622729,
1968820,
1726379,
1322721,
1820151,
520831,
1039808,
1365535,
1523267,
1868580,
1310971,
1770023,
661409,
1822790,
1422980,
1928035,
1927975,
1970417,
1923137,
1322947,
1868507,
1650487,
1526913,
1928051,
1372531,
1927992,
1970916,
1622765,
1722483,
1237749,
1622717,
1970390,
1474063,
1568474,
1726469,
1968942,
1530466,
1872540,
1523245,
1871068,
1927958,
1971126,
1822807,
1622758,
1868506,
1423060,
1534535,
1710973,
1222187,
1620009,
1663917,
1022687,
1151044,
1622732,
1566147,
1868614,
1868542,
1337475,
1822823,
1927959,
1871251,
1822584,
1528654,
1726440,
1824944,
1420629,
1969100,
1968193,
1868626
)
AND
RTRIM(t.test_type) IN
(
'VRSNT',
'TOEFLI',
'TOEFLS',
'IELTSS',
'ITAA',
'SPEAK'
)
GROUP BY t.system_key, t.test_type
ORDER BY t.system_key
;