Back to Samples

Database sample

Write a query that lists FIRST_NAME, LAST_NAME from the STUDENTS table and the average of the PERCENT column from the GRADES table.
Both tables contain STUDENT_ID. Only match records where the GRADELEVEL column is 9, 10, 11, or 12.

Student ID First name Last name

Student ID Grades Percent

First name Last name Average