Infosys interview question

Analytical function,aggregate function,basics of sql,