Pregunta de entrevista de ClearOps (Germany)

How do you select this information from this SQL table