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 today's work:
create table teamstats (name varchar(10) not null, pos varchar(3) not null, ab numeric(3) not null, hits numeric(4) not null, walks varchar(5) not null, singles varchar(7) not null, doubles varchar(7) not null, triples varchar(7) not null, hr numeric(2) not null, so varchar(2) not null); create table characters (lastname varchar(15) not null, firstname varchar(15) not null, m char(1) ...
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.