Wooga Interview Question

What is wrong with this SQL query provided? Please correct it.