1) Does Lost Time always sell for the same price (hint: join the sale and book)?

2) A customer from which state purchased the most copies of Grant Me Three Wishes (hint: join the sale, customer and book)

3) Which book has sold the most copies in a single state (hint: use GROUP BY)?

4) Are total sales the same when you 1) join sale, customer and book, or 2) join all the tables? Why is that?

5) In the state of Oklahoma (‘OK’), what book with more than one author has the highest sale quantity (hint: use subquery to get the book with more than one authors)?

Transcribed Image Text:

sale id customer book id custid bookauthor author id firstname lastname address city bookid authorid bookid unitprice quantity date title publisher category price firstname lastname birthdate state zip sale id customer book id custid bookauthor author id firstname lastname address city bookid authorid bookid unitprice quantity date title publisher category price firstname lastname birthdate state zip

Answer rating: 100% (QA)

Answer Explanation 1 NO Lost Time always Will not sell for the sa... View the full answer