Errata for Sams Teach Yourself SQL in 10 Minutes (Fifth Edition)

As much as I’d like to be able to produce completely error free books, the reality of the computer publishing industry is that the pace at which books must be written and released makes this very difficult. And regretfully, my own books do have sporadic mistakes and typos scattered throughout them.

For the benefit of my readers, here is a current errata for Sams Teach Yourself SQL in 10 Minutes (Fifth Edition). Feel free to print this page for future reference.

And as always, if you come across errors that I do not know about, please let me know. I’ll make sure they are added to this list, and will try to have them corrected in future reprints.

Original printing (306 pages, published December 20, 2019)

311st challenge: (cust_names)Should be: (cust_name)
43Output blockShould include column prod_id
53Tip, 'LIKE'Should be: LIKE ''
72Table 8.2, Function column, first entryMissing closing )
78Challenge 1, text “customer name (customer_name)”Should be: customer name (cust_name)
88Challenge 2, text "of product item(prod_item)"Should be: of products with an id (prod_id)
106Challenge 3, final words "from Customers"Should be: from Orders
129Second INPUT blockShould be:
SELECT cust_name, cust_contact, cust_email
FROM Customers
WHERE cust_state IN ('IL','IN','MI') OR cust_name='Fun4All';