尝试解决MySQL查询逻辑问题的新手

I'm going to try to explain this as simply as possible. Any help would be greatly appreciated as I'm not very good with designing queries.I'm going to try to explain this as simply as p