Pregunta de entrevista de Cognizant

Index in sql , rank in sql, parameter and variable, aggregator, remove distinct records