Sams Teach Yourself SQL in 21 Days, Fourth Edition

Workshop

The Workshop provides quiz questions to help solidify your understanding of the material covered, as well as exercises to provide you with experience in using what you have learned. Try to answer the quiz and exercise questions before checking the answers in Appendix A, “Answers.”

Here are the CREATE TABLE statements and INSERT statements for the FRIENDS and PRICE tables. Type the following code into MySQL if you have not already done so.

 create table friends (lastname varchar(15) not null, firstname varchar(15) not null, areacode numeric(3) null, phone varchar(9) null, st char(2) not null, zip varchar(5) not null); insert into friends values ('BUNDY', 'AL', '100', '5551111', 'IL', '22333'); insert into friends values ('MEZA', 'AL', ...