Reference no: EM132757585
1. Use subquery to answer the following question Do authors sell best at stores in their home state?a. b. List the state and total sales revenue from books sold in that state where at least one of the authors is from that state. Do not count a book multiple times if it has multiple authors from the given state. Assume that sales revenue is calculated by multiplying the quantity sold by the price.
List the state and total sales revenue from books sold in that state where at least one of the authors is not from that state. Again - avoid duplicates and calculate the sales revenue as in a
c. make a query that will return most discounted book. In return your query will display the title of the book,author name,publisher name, store name and price after discount.
1. Use subquery to answer the following question
Does authors sell best at stores in their home state?
a. List the state and total sales revenue from books sold in that state where at least one of the authors is from that state. Do not count a book multiple times if it has multiple authors from the given state. Assume that sales revenue is calculated by multiplying the quantity sold by the price.
b. List the state and total sales revenue from books sold in that state where at least one of the authors is not from that state. Again - avoid duplicates and calculate the sales revenue as in a
c. Make a query that will return most discounted book. In return your query will display the title of the book,author name,publisher name, store name and price after discount.