CTS interview question

What is SQL join, analytical function