Cognizant interview question

Write a SQL query for a specific request