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.” This is the code for the CREATE table and INSERT statements for the PARTS and ORDERS tables, which will be used in this Workshop.

 create table part (partnum numeric(10) not null, description varchar(20) not null, price decimal(10,2) not null); create table orders (orderedon date, name varchar(10) not null, partnum numeric(10) not null, quantity numeric(10) not null, remarks varchar(30) not null); insert into part values ('54', 'PEDALS', '54.25'); insert into ...