Create a query that will let you create a new price list for books written by the same author. You do not want to have to key in the entire name, just the first three letters of the last name and the first letter of the first name. The report should show the ISBN, the title in mixed case, the authors name, current retail price, and the new price. Calculate the new discounted price based on the current retail price minus 12%. Round the result to cents (two decimals). For testing, discount the price of James Patterson's books.

CUSTOMERS Customer Lastname Firstname Email Address City State Zip Referred Region ORDERS Order# Customer Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost ORDERITEMS Order# Item# ISBN Quantity Paideach BOOKAUTHOR AUTHOR BOOKS ISBN Authors ISBN AuthorID Lname Title Fname Pubdate PublD Cost Retail Discount PUBLISHER Category PublD Name PROMOTION Contact Phone Gift Minretail Maxretail FIGURE 1-5 JustLee Books's table structures after normalization