The Predictive Index interview question

You were given a schema and asked how to write SQL to pull the data they want.