Infosys Interview Question

Analytical function,aggregate function,basics of sql,