Sams Teach Yourself SQL in 10 Minutes (Fifth Edition) includes challenges at the end of some lessons. Solutions to the challenges are presented here. Just keep in mind that there is rarely one solution to a SQL challenge, so if your solutions look different but produce the desired result, that’s ok.

Lesson 17

Add a web site column (vend_web) to the Vendors table. You’ll want a text field big enough to accommodate a URL.


ALTER TABLE Vendors
ADD vend_web CHAR(100);
Category: Lesson 17

Use UPDATE statements to update Customer records with phone numbers.


UPDATE Vendors
SET vend_web = 'https://google.com/'
WHERE vend_id = 'DLL01';
Category: Lesson 17

Load More