Question d’entretien chez CTS

What is SQL join, analytical function