Cognizant Interview Question

Sql Query based on schema diagram and transactions.