Elanco interview question

querying data spread across multiple tables