3) Given the following tables, you have been tasked to generate a list of students, one
record per student, which meets the listed required fields and conditions. Describe or
list specific queries you would use and your processing steps.
Required fields & Conditions:
Fields: Student ID, Student Last and First Name, Student Grade Level, Student Gender,
Student Ethnicity
Conditions: Additionally list any Math course marks (Display fields: Course ID, Course
Name, Course Teacher, Course Term and Course Mark) for semesters 1 and 2 and their
CAASPP Math scores and performance levels (Display fields: Test Name, Test Version, Test
Type, Test Scale Score, Test Performance Level) during the last two years. The list should
only include a student if the student had a Math mark of an A or B in either semester or the
CAASPP Math Performance Level was met or exceeded in any of the last two years.
Students:
Courses:
Tests: