The Predictive Index Interview Question

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