如何让rails在这个迭代中执行正确的单个SQL连接查询?

I have basically no experience with Rails, and I'm trying to help a friend who is learning how to program, but I have a lot of experience with SQL, and I'm struggling to get Rails to do the right thing for a simple query with a join.I have basically no experience with Rails, and