Practical SQL Handbook, The: Using SQL Variants, Fourth Edition

titles Table

The titles table stores information about books put out by bookbiz publishers. There are 18 books. The title_id, type and pub_id columns are fixed-length character datatype. The title and notes columns are variable-length datatype. The price and advance columns hold money values (decimal datatypes for systems that do not support a currency datatype). There is a unique index on title_id and a nonunique one on title.

title_id not null titleidind	Title not null titleind	type null	pub_id null	price null	advance null	ytd_sales null	contract not null	notes null	pubdate null
==========	===========	============	======	======	========	=========	========	===============	=======
PC1035	But Is It User Friendly?	popular_comp	1389	42.95	7000.00	8780	1	A survey of software ...