thoughtbot Interview Question

Given this relationship between two different models, write an SQL statement that returns X.