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.