Infinita Consulting interview question

SQL errors you need to solve it