Cognizant Interview Question

Basic sql joins and Oops concepts