use [booksdb]
insert into book(authorid,subjectid,title,price,pubdate) values (49,14,'1000 Years, 1000 People: Ranking the Men and Women Who Shaped the Millennium',67.25,'1999'); 
insert into book(authorid,subjectid,title,price,pubdate) values (57,15,'A Brief History of Time',44.25,'1988'); 
insert into book(authorid,subjectid,title,price,pubdate) values (132,8,'Adventures of Huckleberry Finn, The',30.75,'1884'); 
insert into book(authorid,subjectid,title,price,pubdate) values (133,4,'Adventures of the Rat Family',67.75,'1891'); 
insert into book(authorid,subjectid,title,price,pubdate) values (132,8,'Adventures of Tom Sawyer, The',96.75,'1876'); 
insert into book(authorid,subjectid,title,price,pubdate) values (14,8,'Alice''s Adventures in Wonderland',49.25,'1865'); 
insert into book(authorid,subjectid,title,price,pubdate) values (109,10,'All Quiet on the Western Front',88.75,'1929'); 
insert into book(authorid,subjectid,title,price,pubdate) values (8,6,'All the Way to Lhasa: A Tale From Tibet',79.5,'2002'); 
insert into book(authorid,subjectid,title,price,pubdate) values (118,2,'All''s Well That Ends Well',52.75,'1623'); 
insert into book(authorid,subjectid,title,price,pubdate) values (106,8,'Amber Spyglass, The',64.25,'2000'); 
insert into book(authorid,subjectid,title,price,pubdate) values (38,11,'American Psycho',96.25,'1991'); 
insert into book(authorid,subjectid,title,price,pubdate) values (10,9,'Angels and Demons',91.5,'2000'); 
insert into book(authorid,subjectid,title,price,pubdate) values (74,1,'Angels in America, Part One: Millennium Approaches',71.25,'1992'); 
insert into book(authorid,subjectid,title,price,pubdate) values (74,1,'Angels in America, Part Two: Perestroika (Revised Version)',43.5,'1992'); 
insert into book(authorid,subjectid,title,price,pubdate) values (101,10,'Animal Farm',37.25,'1945'); 
insert into book(authorid,subjectid,title,price,pubdate) values (8,6,'Animalia',34.75,'1982'); 
insert into book(authorid,subjectid,title,price,pubdate) values (119,2,'Arms and the Man',93.99,'1894'); 
insert into book(authorid,subjectid,title,price,pubdate) values (33,6,'Beauty Sleep',36.99,'1902'); 
insert into book(authorid,subjectid,title,price,pubdate) values (91,6,'Beauty: A Retelling of the Story of Beauty and the Beast',108.5,'1978'); 
insert into book(authorid,subjectid,title,price,pubdate) values (4,3,'Becket, or the Honor of God',108.75,'1959'); 
insert into book(authorid,subjectid,title,price,pubdate) values (94,14,'Benjamin Franklin',45.99,'2002'); 
insert into book(authorid,subjectid,title,price,pubdate) values (89,14,'Birds of Heaven: Travels with Cranes, The',45.5,'2003'); 
insert into book(authorid,subjectid,title,price,pubdate) values (108,6,'Bitterblooms',82.25,'1977'); 
insert into book(authorid,subjectid,title,price,pubdate) values (62,4,'Blind God, The',95.5,'1997'); 
insert into book(authorid,subjectid,title,price,pubdate) values (16,5,'Bloody Chamber, The',65.5,'1979'); 
insert into book(authorid,subjectid,title,price,pubdate) values (21,5,'Briar Rose',119.25,'1996'); 
insert into book(authorid,subjectid,title,price,pubdate) values (144,4,'Brothers of the Wind',90.5,'1981'); 
insert into book(authorid,subjectid,title,price,pubdate) values (71,11,'Carrie',21.75,'1974'); 
insert into book(authorid,subjectid,title,price,pubdate) values (58,10,'Catch-22',105.25,'1961'); 
insert into book(authorid,subjectid,title,price,pubdate) values (90,4,'Changeling Sea, The',20.75,'1988'); 
insert into book(authorid,subjectid,title,price,pubdate) values (26,8,'Charlie and the Chocolate Factory',94.75,'1964'); 
insert into book(authorid,subjectid,title,price,pubdate) values (86,14,'Churchill: Visionary, Statesman, Historian',113.75,'2004'); 
insert into book(authorid,subjectid,title,price,pubdate) values (46,14,'Cicely Mary Barker: A Croydon Artist',107.99,'1989'); 
insert into book(authorid,subjectid,title,price,pubdate) values (5,14,'Colossal P. T. Barnum Reader: Nothing Else Like It In the Universe, The ',76.99,'2006'); 
insert into book(authorid,subjectid,title,price,pubdate) values (110,14,'Constable in the Wilderness',119.75,'2004'); 
insert into book(authorid,subjectid,title,price,pubdate) values (42,8,'Coraline',80.75,'2002'); 
insert into book(authorid,subjectid,title,price,pubdate) values (115,15,'Cosmic Connection, The ',38.5,'1973'); 
insert into book(authorid,subjectid,title,price,pubdate) values (115,15,'Cosmos',64.75,'1980'); 
insert into book(authorid,subjectid,title,price,pubdate) values (35,7,'Count of Monte Cristo, The',104.99,'1845'); 
insert into book(authorid,subjectid,title,price,pubdate) values (34,9,'Crime and Punishment',96.75,'1866'); 
insert into book(authorid,subjectid,title,price,pubdate) values (92,1,'Crucible: A Play in Four Acts, The',81.25,'1953'); 
insert into book(authorid,subjectid,title,price,pubdate) values (125,10,'Cryptonomicon',49.99,'1999'); 
insert into book(authorid,subjectid,title,price,pubdate) values (112,3,'Cyrano de Bergerac',54.25,'1897'); 
insert into book(authorid,subjectid,title,price,pubdate) values (10,10,'Da Vinci Code, The',69.25,'2003'); 
insert into book(authorid,subjectid,title,price,pubdate) values (98,14,'Darby''s Rangers: We Led the Way',105.75,'2003'); 
insert into book(authorid,subjectid,title,price,pubdate) values (71,13,'Dark Tower III: The Waste Lands, The',104.75,'1991'); 
insert into book(authorid,subjectid,title,price,pubdate) values (71,13,'Dark Tower IV: Wizard and Glass, The',100.5,'1997'); 
insert into book(authorid,subjectid,title,price,pubdate) values (131,14,'Darkness Visible: Inside the World of Philip Pullman',56.99,'2003'); 
insert into book(authorid,subjectid,title,price,pubdate) values (92,1,'Death of a Salesman',61.99,'1949'); 
insert into book(authorid,subjectid,title,price,pubdate) values (91,5,'Deerskin',57.75,'1994'); 
insert into book(authorid,subjectid,title,price,pubdate) values (43,15,'Dialogue Concerning the Two Chief World Systems',75.99,'1632'); 
insert into book(authorid,subjectid,title,price,pubdate) values (10,7,'Digital Fortress',118.25,'1996'); 
insert into book(authorid,subjectid,title,price,pubdate) values (116,3,'Dirty Hands',70.25,'1948'); 
insert into book(authorid,subjectid,title,price,pubdate) values (11,6,'Djinn in the Nightingale''s Eye, The',76.5,'1994'); 
insert into book(authorid,subjectid,title,price,pubdate) values (91,6,'Door in the Hedge, The',35.5,'1981'); 
insert into book(authorid,subjectid,title,price,pubdate) values (136,15,'Double Helix, The ',45.99,'1968'); 
insert into book(authorid,subjectid,title,price,pubdate) values (127,11,'Dracula',59.5,'1897'); 
insert into book(authorid,subjectid,title,price,pubdate) values (71,11,'Dreamcatcher',27.75,'2001'); 
insert into book(authorid,subjectid,title,price,pubdate) values (104,2,'Dumb Waiter, The',108.99,'1960'); 
insert into book(authorid,subjectid,title,price,pubdate) values (129,14,'Eminent Victorians',62.5,'2003'); 
insert into book(authorid,subjectid,title,price,pubdate) values (2,4,'Emperor''s New Clothes, The',106.5,'1837'); 
insert into book(authorid,subjectid,title,price,pubdate) values (13,5,'Enchantment',77.25,'1999'); 
insert into book(authorid,subjectid,title,price,pubdate) values (128,2,'Every Good Boy Deserves Favour',108.75,'1977'); 
insert into book(authorid,subjectid,title,price,pubdate) values (124,14,'Famous People in History',23.75,'1999'); 
insert into book(authorid,subjectid,title,price,pubdate) values (40,15,'Feynman Lectures on Physics, The ',62.25,'1963'); 
insert into book(authorid,subjectid,title,price,pubdate) values (102,11,'Fight Club',45.75,'1996'); 
insert into book(authorid,subjectid,title,price,pubdate) values (137,15,'First Three Minutes, The ',32.99,'1977'); 
insert into book(authorid,subjectid,title,price,pubdate) values (116,3,'Flies, The',80.75,'1943'); 
insert into book(authorid,subjectid,title,price,pubdate) values (138,14,'Footnote*',88.25,'2004'); 
insert into book(authorid,subjectid,title,price,pubdate) values (120,11,'Frankenstein',101.75,'1818'); 
insert into book(authorid,subjectid,title,price,pubdate) values (84,15,'Gaia',115.25,'1979'); 
insert into book(authorid,subjectid,title,price,pubdate) values (45,14,'Ganging Up',68.5,'1999'); 
insert into book(authorid,subjectid,title,price,pubdate) values (51,6,'German Fairy Tales',114.75,'1985'); 
insert into book(authorid,subjectid,title,price,pubdate) values (123,14,'Getting a Life: Everyday Uses of Autobiography',119.75,'1996'); 
insert into book(authorid,subjectid,title,price,pubdate) values (145,5,'Godson',112.5,'1994'); 
insert into book(authorid,subjectid,title,price,pubdate) values (106,8,'Golden Compass, The',35.99,'1995'); 
insert into book(authorid,subjectid,title,price,pubdate) values (78,5,'Golden Rope, The',117.25,'1983'); 
insert into book(authorid,subjectid,title,price,pubdate) values (122,1,'Good Doctor, The',45.99,'1974'); 
insert into book(authorid,subjectid,title,price,pubdate) values (70,5,'Goose Chase',53.75,'2001'); 
insert into book(authorid,subjectid,title,price,pubdate) values (53,5,'Goose Girl, The',39.75,'2003'); 
insert into book(authorid,subjectid,title,price,pubdate) values (41,15,'Gorillas in the Mist',79.75,'1983'); 
insert into book(authorid,subjectid,title,price,pubdate) values (71,11,'Green Mile, The',83.5,'1996'); 
insert into book(authorid,subjectid,title,price,pubdate) values (71,13,'Gunslinger, The',31.99,'1982'); 
insert into book(authorid,subjectid,title,price,pubdate) values (118,2,'Hamlet',45.99,'2003'); 
insert into book(authorid,subjectid,title,price,pubdate) values (140,4,'Happy Prince, The',22.5,'1888'); 
insert into book(authorid,subjectid,title,price,pubdate) values (113,8,'Harry Potter and the Chamber of Secrets',116.25,'1998'); 
insert into book(authorid,subjectid,title,price,pubdate) values (113,8,'Harry Potter and the Goblet of Fire',75.5,'2000'); 
insert into book(authorid,subjectid,title,price,pubdate) values (113,8,'Harry Potter and the Half-Blood Prince',30.5,'2005'); 
insert into book(authorid,subjectid,title,price,pubdate) values (113,8,'Harry Potter and the Order of the Phoenix',21.75,'2003'); 
insert into book(authorid,subjectid,title,price,pubdate) values (113,8,'Harry Potter and the Philosopher''s Stone',93.25,'1997'); 
insert into book(authorid,subjectid,title,price,pubdate) values (113,8,'Harry Potter and the Prisoner of Azkaban',32.99,'1999'); 
insert into book(authorid,subjectid,title,price,pubdate) values (24,2,'Hay Fever',60.75,'1925'); 
insert into book(authorid,subjectid,title,price,pubdate) values (19,7,'Heart of Darkness',100.25,'1902'); 
insert into book(authorid,subjectid,title,price,pubdate) values (119,2,'Heartbreak House',27.5,'1920'); 
insert into book(authorid,subjectid,title,price,pubdate) values (118,2,'Henry V',91.5,'2000'); 
insert into book(authorid,subjectid,title,price,pubdate) values (118,2,'Henry VIII',27.5,'1923'); 
insert into book(authorid,subjectid,title,price,pubdate) values (130,8,'Hobbit, The',48.75,'1937'); 
insert into book(authorid,subjectid,title,price,pubdate) values (103,14,'Home Before Daylight: My Life on the Road with the Grateful Dead',73.99,'2005'); 
insert into book(authorid,subjectid,title,price,pubdate) values (80,8,'Horse and His Boy, The',109.5,'1954'); 
insert into book(authorid,subjectid,title,price,pubdate) values (140,2,'Ideal Husband, an',48.99,'1895'); 
insert into book(authorid,subjectid,title,price,pubdate) values (64,14,'Imaginary Girlfriend: A Memoir, The ',66.5,'1997'); 
insert into book(authorid,subjectid,title,price,pubdate) values (93,3,'Imaginary Invalid, The',62.75,'1673'); 
insert into book(authorid,subjectid,title,price,pubdate) values (105,4,'Imperial Messages',109.5,'1976'); 
insert into book(authorid,subjectid,title,price,pubdate) values (140,2,'Importance of Being Earnest, The',74.5,'1895'); 
insert into book(authorid,subjectid,title,price,pubdate) values (87,14,'In the Pirate''s Den: My Life as a Secret Agent for Castro',70.99,'2002'); 
insert into book(authorid,subjectid,title,price,pubdate) values (75,1,'Inherit the Wind',49.5,'1955'); 
insert into book(authorid,subjectid,title,price,pubdate) values (143,15,'Insect Societies, The ',26.25,'1971'); 
insert into book(authorid,subjectid,title,price,pubdate) values (71,11,'Insomnia',40.75,'1994'); 
insert into book(authorid,subjectid,title,price,pubdate) values (111,11,'Interview with the Vampire',50.25,'1976'); 
insert into book(authorid,subjectid,title,price,pubdate) values (71,11,'It',33.99,'1986'); 
insert into book(authorid,subjectid,title,price,pubdate) values (12,6,'Italian Folktales',69.75,'1956'); 
insert into book(authorid,subjectid,title,price,pubdate) values (82,14,'John Barleycorn',106.5,'2002'); 
insert into book(authorid,subjectid,title,price,pubdate) values (99,14,'John Wesley: Paintings 1961-2000',85.5,'2000'); 
insert into book(authorid,subjectid,title,price,pubdate) values (81,15,'Journals of Lewis and Clark, The ',78.75,'1814'); 
insert into book(authorid,subjectid,title,price,pubdate) values (25,7,'Jurassic Park',115.25,'1990'); 
insert into book(authorid,subjectid,title,price,pubdate) values (139,6,'Kauai Tales',77.99,'1985'); 
insert into book(authorid,subjectid,title,price,pubdate) values (118,2,'King Lear',69.5,'1608'); 
insert into book(authorid,subjectid,title,price,pubdate) values (80,12,'Last Battle, The',116.99,'1956'); 
insert into book(authorid,subjectid,title,price,pubdate) values (52,14,'Leaves from the Life of a Country Doctor',62.75,'2002'); 
insert into book(authorid,subjectid,title,price,pubdate) values (95,4,'Libussa',82.25,'1786'); 
insert into book(authorid,subjectid,title,price,pubdate) values (85,14,'Life of Huien Tsang',26.99,'2002'); 
insert into book(authorid,subjectid,title,price,pubdate) values (80,12,'Lion, The Witch and the Wardrobe, The',26.99,'1950'); 
insert into book(authorid,subjectid,title,price,pubdate) values (2,6,'Little Claus and Big Claus',95.75,'1835'); 
insert into book(authorid,subjectid,title,price,pubdate) values (2,4,'Little Mermaid, The',58.75,'1837'); 
insert into book(authorid,subjectid,title,price,pubdate) values (47,7,'Lord of the Flies',67.5,'1954'); 
insert into book(authorid,subjectid,title,price,pubdate) values (8,4,'Lot of Otters, a',77.75,'1997'); 
insert into book(authorid,subjectid,title,price,pubdate) values (56,14,'Love and Other Infectious Diseases: A Memoir',38.25,'2000'); 
insert into book(authorid,subjectid,title,price,pubdate) values (118,2,'Macbeth',104.99,'1623'); 
insert into book(authorid,subjectid,title,price,pubdate) values (96,5,'Magic Circle, The',114.25,'1993'); 
insert into book(authorid,subjectid,title,price,pubdate) values (80,12,'Magician''s Nephew, The',40.99,'1955'); 
insert into book(authorid,subjectid,title,price,pubdate) values (63,5,'Mama Don''t Allow',77.25,'1984'); 
insert into book(authorid,subjectid,title,price,pubdate) values (119,2,'Man and Superman',66.5,'1903'); 
insert into book(authorid,subjectid,title,price,pubdate) values (114,15,'Man Who Mistook His Wife for a Hat and Other Clinical Tales, The ',72.75,'1985'); 
insert into book(authorid,subjectid,title,price,pubdate) values (97,15,'Mathematical Principles of Natural Philosophy',50.5,'1687'); 
insert into book(authorid,subjectid,title,price,pubdate) values (107,6,'Merry Adventures of Robin Hood, The',34.75,'1883'); 
insert into book(authorid,subjectid,title,price,pubdate) values (61,15,'Micrographia',115.25,'1665'); 
insert into book(authorid,subjectid,title,price,pubdate) values (118,2,'Midsummer Night''s Dream, a',116.5,'1600'); 
insert into book(authorid,subjectid,title,price,pubdate) values (93,3,'Misanthrope, The',97.99,'1666'); 
insert into book(authorid,subjectid,title,price,pubdate) values (50,15,'Mismeasure of Man, The ',111.5,'1981'); 
insert into book(authorid,subjectid,title,price,pubdate) values (39,4,'Momo / The Grey Gentlemen',66.99,'1973'); 
insert into book(authorid,subjectid,title,price,pubdate) values (100,1,'Mourning Becomes Electra',105.75,'1931'); 
insert into book(authorid,subjectid,title,price,pubdate) values (17,2,'Mousetrap, The',78.5,'1952'); 
insert into book(authorid,subjectid,title,price,pubdate) values (119,2,'Mrs. Warren''s Profession',43.75,'1893'); 
insert into book(authorid,subjectid,title,price,pubdate) values (118,2,'Much Ado About Nothing',96.75,'1598'); 
insert into book(authorid,subjectid,title,price,pubdate) values (28,14,'My Story: A Photographic Essay of Life with Multiple Sclerosis',89.5,'2004'); 
insert into book(authorid,subjectid,title,price,pubdate) values (36,10,'Name of the Rose, The',107.75,'1980'); 
insert into book(authorid,subjectid,title,price,pubdate) values (42,5,'Nicholas Was...',109.75,'1990'); 
insert into book(authorid,subjectid,title,price,pubdate) values (2,4,'Nightingale, The',92.75,'1843'); 
insert into book(authorid,subjectid,title,price,pubdate) values (116,3,'No Exit and Three Other Plays',38.75,'1955'); 
insert into book(authorid,subjectid,title,price,pubdate) values (126,4,'Nobody''s Son',83.75,'1993'); 
insert into book(authorid,subjectid,title,price,pubdate) values (2,4,'Old House, The',100.5,'1847'); 
insert into book(authorid,subjectid,title,price,pubdate) values (59,7,'Old Man and the Sea, The',107.5,'1952'); 
insert into book(authorid,subjectid,title,price,pubdate) values (134,15,'On the Fabric of the Human Body',104.99,'1543'); 
insert into book(authorid,subjectid,title,price,pubdate) values (22,15,'On the Revolutions of Heavenly Spheres',92.99,'1543'); 
insert into book(authorid,subjectid,title,price,pubdate) values (68,7,'On the Road',38.5,'1957'); 
insert into book(authorid,subjectid,title,price,pubdate) values (44,15,'One Two Three . . . Infinity',75.99,'1947'); 
insert into book(authorid,subjectid,title,price,pubdate) values (66,4,'Ordinary Princess, The',111.99,'1986'); 
insert into book(authorid,subjectid,title,price,pubdate) values (27,15,'Origin of Species, The ',70.25,'1859'); 
insert into book(authorid,subjectid,title,price,pubdate) values (118,2,'Othello',38.99,'1622'); 
insert into book(authorid,subjectid,title,price,pubdate) values (118,2,'Pericles',42.75,'1609'); 
insert into book(authorid,subjectid,title,price,pubdate) values (71,11,'Pet Sematary',56.25,'1983'); 
insert into book(authorid,subjectid,title,price,pubdate) values (60,4,'Pictor''s Metamorphoses and Other Fantasies',109.99,'1981'); 
insert into book(authorid,subjectid,title,price,pubdate) values (20,14,'Plainer Still',87.25,'1996'); 
insert into book(authorid,subjectid,title,price,pubdate) values (122,1,'Plaza Suite',89.75,'1969'); 
insert into book(authorid,subjectid,title,price,pubdate) values (80,8,'Prince Caspian',44.75,'1951'); 
insert into book(authorid,subjectid,title,price,pubdate) values (91,5,'Princess and the Frog, The',79.5,'1981'); 
insert into book(authorid,subjectid,title,price,pubdate) values (48,4,'Princess Bride, The',80.99,'1973'); 
insert into book(authorid,subjectid,title,price,pubdate) values (67,14,'Profiles in Courage',76.99,'1999'); 
insert into book(authorid,subjectid,title,price,pubdate) values (65,14,'Profondo Argento',85.5,'2004'); 
insert into book(authorid,subjectid,title,price,pubdate) values (40,15,'QED: The Strange Theory of Light and Matter',84.5,'1985'); 
insert into book(authorid,subjectid,title,price,pubdate) values (55,1,'Raisin in the Sun, a',117.5,'1959'); 
insert into book(authorid,subjectid,title,price,pubdate) values (54,11,'Reality Dysfunction, The',59.25,'1996'); 
insert into book(authorid,subjectid,title,price,pubdate) values (2,4,'Red Shoes, The',25.75,'1845'); 
insert into book(authorid,subjectid,title,price,pubdate) values (37,15,'Relativity: The Special and General Theory',100.75,'1916'); 
insert into book(authorid,subjectid,title,price,pubdate) values (116,3,'Respectful Prostitute, The',29.75,'1946'); 
insert into book(authorid,subjectid,title,price,pubdate) values (118,2,'Richard III',36.99,'1597'); 
insert into book(authorid,subjectid,title,price,pubdate) values (91,5,'Rose Daughter',37.5,'1997'); 
insert into book(authorid,subjectid,title,price,pubdate) values (119,2,'Saint Joan',109.99,'1923'); 
insert into book(authorid,subjectid,title,price,pubdate) values (71,11,'Salem''s Lot',32.75,'1975'); 
insert into book(authorid,subjectid,title,price,pubdate) values (121,2,'School for Scandal, The',54.99,'1777'); 
insert into book(authorid,subjectid,title,price,pubdate) values (119,2,'Selected One Act Plays',99.75,'1972'); 
insert into book(authorid,subjectid,title,price,pubdate) values (29,15,'Selfish Gene, The ',97.99,'1976'); 
insert into book(authorid,subjectid,title,price,pubdate) values (140,4,'Selfish Giant, The',113.99,'1888'); 
insert into book(authorid,subjectid,title,price,pubdate) values (88,6,'Serafin',106.5,'1999'); 
insert into book(authorid,subjectid,title,price,pubdate) values (83,5,'Seven Daughters and Seven Sons',74.25,'1994'); 
insert into book(authorid,subjectid,title,price,pubdate) values (72,15,'Sexual Behavior in the Human Male',107.75,'1948'); 
insert into book(authorid,subjectid,title,price,pubdate) values (2,4,'Shadow, The',37.75,'1847'); 
insert into book(authorid,subjectid,title,price,pubdate) values (71,11,'Shining, The',27.99,'1977'); 
insert into book(authorid,subjectid,title,price,pubdate) values (15,15,'Silent Spring',70.99,'1962'); 
insert into book(authorid,subjectid,title,price,pubdate) values (80,8,'Silver Chair, The',69.75,'1953'); 
insert into book(authorid,subjectid,title,price,pubdate) values (6,6,'Silver Hoof',26.25,'1938'); 
insert into book(authorid,subjectid,title,price,pubdate) values (23,14,'Silver King: The Remarkable Life of the Count of Regia in Colonial Mexico, The ',83.25,'2003'); 
insert into book(authorid,subjectid,title,price,pubdate) values (96,5,'Sirena',100.75,'1998'); 
insert into book(authorid,subjectid,title,price,pubdate) values (135,10,'Slaughterhouse-Five',57.75,'1966'); 
insert into book(authorid,subjectid,title,price,pubdate) values (125,7,'Snow Crash',113.25,'1992'); 
insert into book(authorid,subjectid,title,price,pubdate) values (2,4,'Snow Queen, The',107.5,'1844'); 
insert into book(authorid,subjectid,title,price,pubdate) values (42,5,'Snow, Glass, Apples',90.99,'1995'); 
insert into book(authorid,subjectid,title,price,pubdate) values (25,11,'Sphere',21.5,'1987'); 
insert into book(authorid,subjectid,title,price,pubdate) values (96,5,'Spinners',64.75,'1999'); 
insert into book(authorid,subjectid,title,price,pubdate) values (71,11,'Stand, The',70.99,'1978'); 
insert into book(authorid,subjectid,title,price,pubdate) values (2,4,'Steadfast Tin Soldier, The',97.5,'1838'); 
insert into book(authorid,subjectid,title,price,pubdate) values (69,14,'Stories and Scenes from Mount Lebanon',82.99,'2004'); 
insert into book(authorid,subjectid,title,price,pubdate) values (142,1,'Streetcar Named Desire, a',95.25,'1947'); 
insert into book(authorid,subjectid,title,price,pubdate) values (32,6,'Strega Nona',81.25,'1975'); 
insert into book(authorid,subjectid,title,price,pubdate) values (73,15,'Structure of Scientific Revolutions, The ',104.25,'1962'); 
insert into book(authorid,subjectid,title,price,pubdate) values (106,8,'Subtle Knife, The',48.75,'1997'); 
insert into book(authorid,subjectid,title,price,pubdate) values (2,4,'Swineherd, The',86.99,'1841'); 
insert into book(authorid,subjectid,title,price,pubdate) values (31,5,'Tam Lin',54.5,'1991'); 
insert into book(authorid,subjectid,title,price,pubdate) values (118,2,'Taming of the Shrew, The',46.99,'1623'); 
insert into book(authorid,subjectid,title,price,pubdate) values (93,3,'Tartuffe',97.25,'1664'); 
insert into book(authorid,subjectid,title,price,pubdate) values (118,2,'Tempest, The',23.25,'1623'); 
insert into book(authorid,subjectid,title,price,pubdate) values (14,8,'Through the Looking Glass',75.25,'1872'); 
insert into book(authorid,subjectid,title,price,pubdate) values (2,4,'Thumbelina',55.25,'1835'); 
insert into book(authorid,subjectid,title,price,pubdate) values (2,6,'Tinderbox, The',31.75,'1835'); 
insert into book(authorid,subjectid,title,price,pubdate) values (77,10,'To Kill a Mockingbird',88.25,'1960'); 
insert into book(authorid,subjectid,title,price,pubdate) values (118,2,'Twelfth Night',30.5,'1623'); 
insert into book(authorid,subjectid,title,price,pubdate) values (1,6,'Unbroken Web, The',110.75,'1980'); 
insert into book(authorid,subjectid,title,price,pubdate) values (141,4,'Uncle Terrible: More Adventures of Anatole',116.99,'1982'); 
insert into book(authorid,subjectid,title,price,pubdate) values (3,15,'Under a Lucky Star',35.5,'1943'); 
insert into book(authorid,subjectid,title,price,pubdate) values (30,4,'Undine',68.5,'1811'); 
insert into book(authorid,subjectid,title,price,pubdate) values (17,2,'Unexpected Guest, The',51.75,'1958'); 
insert into book(authorid,subjectid,title,price,pubdate) values (111,11,'Vampire Lestat, The',30.5,'1985'); 
insert into book(authorid,subjectid,title,price,pubdate) values (9,14,'Virginia Woolf: An Inner Life',41.99,'2005'); 
insert into book(authorid,subjectid,title,price,pubdate) values (27,15,'Voyage of the Beagle, The ',30.5,'1845'); 
insert into book(authorid,subjectid,title,price,pubdate) values (80,8,'Voyage of the ''Dawn Treader'', The',41.25,'1952'); 
insert into book(authorid,subjectid,title,price,pubdate) values (7,3,'Waiting for Godot',68.75,'1952'); 
insert into book(authorid,subjectid,title,price,pubdate) values (1,8,'Watership Down',94.5,'1972'); 
insert into book(authorid,subjectid,title,price,pubdate) values (18,2,'Way of the World, The',91.75,'1700'); 
insert into book(authorid,subjectid,title,price,pubdate) values (117,15,'What Is Life',64.25,'1944'); 
insert into book(authorid,subjectid,title,price,pubdate) values (78,5,'When the Clock Strikes',32.99,'1981'); 
insert into book(authorid,subjectid,title,price,pubdate) values (2,6,'Wild Swans, The',60.75,'1838'); 
insert into book(authorid,subjectid,title,price,pubdate) values (118,2,'Winter''s Tale, The',107.25,'1623'); 
insert into book(authorid,subjectid,title,price,pubdate) values (76,8,'Wizard of Earthsea, A',117.75,'1968'); 
insert into book(authorid,subjectid,title,price,pubdate) values (79,8,'Wrinkle in Time, A',25.99,'1962');