Pregunta de entrevista de CTS

What is SQL join, analytical function