is there someone who's good in database design? (2)

I need to finish project 3 only.

Project 3= creat an SQL query.

(project 3 it's depending on previous project).

I've attached all of them.

thanks