• I got this right because I read the question quickly and didn't notice the missing columns.

    However, I have gotten these questions wrong before where there were deliberate 'mistakes' like this.

    If this question stood on it's own then it is just a typo. Some questions rely on you spotting or not spotting invalid SQL so the assumption of a typo is dangerous (if losing a point is considered a danger).