Pregunta de entrevista de Cognizant

Basic SQL questions. Topics covered: Join, aggregation