Cognizant interview question

Sql Query based on schema diagram and transactions.