如何在给定此关系图的情况下执行此MySQL查询

I have the following relation diagram where arrows represent Foreign Keys. The word in the blue is the table name and the words below are column names.I have the following relation diagram where arr