Saint-Gobain Interview Question

How would you write a query in MySQL