Final Exam Question 18 & 21

Dear 365datascience team:

The code provided in questions 18 + 21&22 doesn't work at all!
For question 18:
    It seems that the code provided in answers dosn't work.
    I got the same error code 1054 to all the answer from 1-4.
    I may need your help on this one!

FOR question 21&22:
    The code provided in question & answer would result in an error code 1292.
    I fix this problem by simply replace the "AND" keyword with a comma (",")

    in BEGIN clause, and everything would be all right!

Thank you!