SQL Case Study: Book Store Sales

Scenario

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.

The database used had 4 tables:

• Books
• Customers
• Orders
• Order_items

The case study involves answering these 10 questions. For each question I have provided a screenshot of the SQL query I ran:

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 places orders6. 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.