Would this INSERT statement work? Errata in textbook?
You are correct, the second would fail due to the extra quote. This may be just a misprint caused by an over-aggressive grammar checker, or indeed it could be an apostrophe rather than a quote, and the font delineation is difficult to determine.


The first one will succeed. 
The second one would fail due to the single quote (if it's a quote)
The third one would fail due to registration being longer than 8 characters (and the quote, if it's a quote)
The fourth one would fail as the HullId is out of range for a tinyint


Side note: why they would put a Hovercraft schema in the Hovercraft database is beyond me, and a great example of nonsensical design.