Answer:
A sample of the statement is written below
SELECT MIN(GRADE), MAX(GRADE), AVG(GRAD), FROM TABLE 2 WHERE TEACHER = "TODD SMYTHE"
Explanation:
To find the Minimum, maximum and average grade of final exams in the sections taught by Todd Smythe. we will write a statement
Using the select to get the required data using the functions ; MIN , MAX , AVG and the WHERE clause for the condition
A sample of the statement is written below
SELECT MIN(GRADE), MAX(GRADE), AVG(GRAD), FROM TABLE 2 WHERE TEACHER = "TODD SMYTHE"
