Wooga interview question

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