Cognizant Interview Question

Basic SQL questions. Topics covered: Join, aggregation