Lesson 1 of 0
In Progress

SQL Case Study 3: Book Store Sales

Kedeisha September 11, 2023

An online bookstore that wants to maximize sales and customer pleasure is the subject of our case study. Your job as a data analyst is to examine sales data and provide conclusions to enhance company performance. You can find patterns, client preferences, and growth prospects by examining data from your books, customers, orders, and sales. In order to increase sales and strengthen the position of the online bookshop in the marketplace, your analysis will help guide decisions about inventory management, marketing initiatives, and customer engagement.

Challenge Questions

  1. Retrieve all books with a price greater than $10. 
  2. Find the total amount spent by each customer in descending order.
  3. Retrieve the top 3 best-selling books based on the total quantity sold.
  4. Find the average price of books in the Fiction genre.
  5. Retrieve the names of customers who have placed orders.
  6. Find the total revenue generated from book sales.
  7. Retrieve the books with titles containing the word “and” (case-insensitive).
  8. Find the customers who have placed orders worth more than $50.
  9. Retrieve the book titles and their corresponding authors sorted in alphabetical order by author.
  10. Find the customers who have not placed any orders.

DB Fiddle Instructions

Click ‘Edit on DB Fiddle’ to be taken to the in browser SQL playground where you can run your queries.