Question 1: Create a new table named FictionCopies using the data in the BookCode, Title, BranchNum, CopyNum, Quality, and Price columns for those books that have the type FIC.
Question 2: Ray Henry is considering increasing the price of all copies of fiction books whose quality is excellent by 10%. To determine the new prices, list the book code, title, and increased price of every book in the FictionCopies table. (Your computed column should determine 110% of the current price, which is 100% plus a 10% increase.)