How do you join nested associations in ActiveRecord, and how do you filter on them correctly?

Topic: rails, ActiveRecord and SQL. Level: Intermediate.

The full answer to this question is available to Interview Reader members. See what is free and what Premium adds.