Pergunta de entrevista da empresa Saint-Gobain

How would you write a query in MySQL