Help with queries to the dataWarehouse.
To retrieve all semesters of all courses in your college and their average run the
following 2 queries
SELECT [course_name], [course_section_number], [instructor1], [semester8],
max(course_Enrollment) AS enrollment, AVG( [response_univ3]) AS [Course Quality],
AVG( [response_univ4]) AS [Instructor Quality]
FROM [srte].[dbo].[response_records]
WHERE ([instructor_code] IS NULL [instructor_code] = 'A')
GROUP BY [course_name], [course_section_number], [instructor1], [semester8]
SELECT [course_name], [course_section_number], [instructor1], [semester8],
max(course_Enrollment) AS enrollment, AVG( [response_univ3]) AS [Course Quality],
AVG( [response_univ4]) AS [Instructor Quality]
FROM [srte].[dbo].[response_records]
WHERE [instructor_code] = 'B')
GROUP BY [course_name], [course_section_number], [instructor1], [semester8]
Return to Paper SRTE Topics
