Listing G
INSERT INTO BOOK
(BOOK_NAME, AUTHOR, PRICE, AVAILABILITY_ID)
SELECT 'Lord Of The Rings','J. R. R. Tolkien',10.00,(SELECT AVAILABILITY_ID FROM AVAILABILITY WHERE AVAILABILITY_NAME='In Stock')
 
 
INSERT INTO BOOK
(BOOK_NAME, AUTHOR, PRICE, AVAILABILITY_ID)
SELECT 'Benjamin Franklin: An American Life','Walter Isaacson',21.00,(SELECT AVAILABILITY_ID FROM AVAILABILITY WHERE AVAILABILITY_NAME='In Stock')
 
 
INSERT INTO BOOK
(BOOK_NAME, AUTHOR, PRICE, AVAILABILITY_ID)
SELECT 'Seabiscuit: An American Legend','Laura Hillenbrand',9.57,(SELECT AVAILABILITY_ID FROM AVAILABILITY WHERE AVAILABILITY_NAME='In Stock')
 
 
INSERT INTO BOOK
(BOOK_NAME, AUTHOR, PRICE, AVAILABILITY_ID)
SELECT 'Beach House','James Patterson, Peter De Jonge',4.79,(SELECT AVAILABILITY_ID FROM AVAILABILITY WHERE AVAILABILITY_NAME='In Stock')
 
 
INSERT INTO BOOK
(BOOK_NAME, AUTHOR, PRICE, AVAILABILITY_ID)
SELECT 'Angels and Demons','Dan Brown',5.59,(SELECT AVAILABILITY_ID FROM AVAILABILITY WHERE AVAILABILITY_NAME='In Stock')
 
 
INSERT INTO BOOK
(BOOK_NAME, AUTHOR, PRICE, AVAILABILITY_ID)
SELECT 'Gettysburg','Stephen W. Sears',21.00,(SELECT AVAILABILITY_ID FROM AVAILABILITY WHERE AVAILABILITY_NAME='In Stock')
 
 
INSERT INTO BOOK
(BOOK_NAME, AUTHOR, PRICE, AVAILABILITY_ID)
SELECT 'The Teeth of the Tiger','Tom Clancy',19.56,(SELECT AVAILABILITY_ID FROM AVAILABILITY WHERE AVAILABILITY_NAME='In Stock')
 
 
INSERT INTO BOOK
(BOOK_NAME, AUTHOR, PRICE, AVAILABILITY_ID)
SELECT 'Netter''s Atlas of Human Anatomy','Frank H. Netter,John T. Hansen',48.26,(SELECT AVAILABILITY_ID FROM AVAILABILITY WHERE AVAILABILITY_NAME='In Stock')