Cognizant interview question

Simple questions on SQL joins