Question d’entretien chez E-Ring

Write an appropriate sql query?