Saint-Gobain interview question

How would you write a query in MySQL