Question d’entretien chez Chubb

How will u write this query in SQL?