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.

Permalink

Reply