Given the table marks containing the details of marks obtained by students containing the following columns

Student_id : Storing the id of the student

Course : Storing the name of the course

Marks : Storing the marks obtained by the student in the particular course

and the table teacher containing the details of the teacher with the following columns

Teacher_name : Storing the name of the teacher

Course : Storing the course taught by the teacher

Write a query to find the name of the teacher teaching the course with the highest average.

Hint: The SQL query skeleton may look something like this.

select "column name"

from "table name"

where course =

(

select __

from __

group by __

__ __ desc

limit __

);