Roche interview question

Handling Conflict with client Predictive and descriptive analysis Sql query