正确地执行ruby on rails的查询

I'm just beginning with ruby on rails and have a question regarding a bit more complex query. So far I've done simple queries while looking at rails guide and it worked really well. I'm just beginning with ruby on rails and have