Question

Find the minimum, maximum, and average grade of final exams in sections taught by Todd Smythe.

Answer 1

A sample of the statement is written below

SELECT MIN(GRADE), MAX(GRADE), AVG(GRAD), FROM TABLE 2 WHERE TEACHER = "TODD SMYTHE"

Step-by-step 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"