If the student manually types in the WHERE filter in step 3 and tries to save the query as a view it will fail.
It is not made clear in the instructions that the view will only save if the semicolon statement terminator is removed.
If the student uses the code copy feature in the VM the problem does not occur as the semi colon has been removed from the code in step 3 that was present in step 2.
Module: 11 Lab Task: Saving a view Step: 03
Description of issue
If the student manually types in the WHERE filter in step 3 and tries to save the query as a view it will fail. It is not made clear in the instructions that the view will only save if the semicolon statement terminator is removed. If the student uses the code copy feature in the VM the problem does not occur as the semi colon has been removed from the code in step 3 that was present in step 2.