Cognizant interview question

Basic SQL questions. Topics covered: Join, aggregation