Doubt in SQL Masterclass

Sir, there is an error being shown when I try to run these statements. I am attaching the statement and the issue I faced. Please clear my doubts as soon as possible. The datasheet in class 2 has some error I beleive.