Reference no: EM132865017

Question - We want to create a query that will let us see a new price list for the books written by the same author. We do not want to "key in" the entire name, just the first 4 letters of the last name and the first 2 letters of the first name. We want to calculate the new discounted price based on the current retail price minus 7%. For testing, discount the price of James Patterson books. What single-row functions would we want to utilize? Share your full or partial query.