Cognizant interview question

Basic SQL queries based on joins and questions like Acid properties