first questionn and the second question as sql script AS INNER JION

THE SECOND

This is the EER diagram

for the first question l did as below but the query is not running

the query is not running and also l need the query for the second question

[7] Write a Do-It-Yourself (DIY) query of your own design for the College database that inner joins at least four tables. One of the tables must be the Semester table. This needs to be a new query. It must not be a query from elsewhere in the course or a previous query with only minor modifications and the query must have some meaningful purpose. Give the columns good names and sort the results as appropriate. Format the output neatly. Write a one sentence explanation of the query. In your explanation tell me the purpose of the query, not how it works. i.e. don't tell me "joined A to B and B to C... can see that by looking at your SQL [7] Write a Do-It-Yourself (DIY) query of your own design for the College database that inner joins at least four tables. One of the tables must be the Semester table. This needs to be a new query. It must not be a query from elsewhere in the course or a previous query with only minor modifications and the query must have some meaningful purpose. Give the columns good names and sort the results as appropriate. Format the output neatly. Write a one sentence explanation of the query. In your explanation tell me the purpose of the query, not how it works. i.e. don't tell me "joined A to B and B to C... can see that by looking at your SQL