Can you please help me with this! I am complelty lost, I am trying to use SQL data tools - I know I need Sections and Instructor table but what else?

QUERY Create a query that shows ebook revenue by instructor, sorted in descending order by revenue.

Instructor Last Name - Instructor First Name - DEPARTMENT_ID - REVENUE

I also need a chart that shows enrollments by department!

DEPT_NAME - ENROLLMENT

Any help would be amazing, Thanks

DATABASE DIAGRAM SUBJECTS COLLEGE COURSES SUBJECT-ID SUBJECTNAME COLLEGE ID COURSECODE SUBJECT_ID COURSE_NUMBER HOURS COURSE NAME COLLEGE_NAME - COLLEGEID - DEPARTMENTS DEPARTMENT ID DEPT NAME COLLEGE_ID INSTRUCTOR INSTRUCTOR_ID INSTRUCTOR LAST NAME INSTRUCTOR FIRST_NAME INSTRUCTOR_EMAIL DEPARTMENT ID SECTIONS SECTION ENROUIMENT COURSE CODE INSTRUCTOR_ID SEMESTER SECTION YEAR ISBN EBOOKS ISBN PRICE ONLINE LAB PUBLISHER