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.” These statements allow you to create and populate the ORGCHART table.

 create table orgchart (name varchar(15) not null, team varchar(11) not null, salary decimal(10,2) not null, sickleave numeric(10) not null, annualleave numeric(11) not null); insert into orgchart values ('ADAMS', 'RESEARCH', '34000.00', '34', '12'); insert into orgchart values ('WILKES', 'MARKETING', '31000.00', '40', '9'); insert into orgchart values ('STOKES', 'MARKETING', '36000.00', ...