TA_ENGL_105.sql

USE UWSDBDataStore;

GO

SELECT TOP 100 
	s1.student_no,
	s1.student_name_lowc,
	ct.dept_abbrev,
	ct.course_number,
	grade
FROM sec.transcript_courses_taken ct
INNER JOIN sec.student_1 s1
ON ct.system_key = s1.system_key
WHERE RTRIM(ct.dept_abbrev) = 'ENGL'
AND ct.course_number = 105
AND 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
	)
;