Question d’entretien chez Aylo

How would you optimize this SQL query?