Question d’entretien chez Swiss Re

How to join and group in sql