NEED IN ORACLE SQL

Faculty are awarded bonuses based on the progress made by students in their courses.

Write a query that outputs the faculty First Name, Last Name, and an average of the progress (Avg. Progress) made over all of their courses.

department course Column Name Data Type Allow Nulls Data Type Column Name Allow Nulls g id name varchar(30) varchar(50) name deptld faculty Column Name Data Type Allow Nulls id lastname varchar(50) deptld studentCourse Column Name Data Type Allow Nulls studentld courseld progress startDate student Column Name Data Type Allow Nulls date varchar(30) varchar(50) lastname street streetDetail varchar(30) varchar(30) varchar(30) char(5) facultyCourse Column Name Data Type Allow Nulls postalCode majorld facultyld courseld