SQL Online Bookstore Project 📚 This project contains SQL queries for managing and analyzing an Online Bookstore Database. The queries help retrieve book details, manage orders, track inventory, and analyze customer data.
📌 Features & Queries Included Book Management
Retrieve all books in a specific genre. Find books published after a certain year. List all available book genres. Find the most expensive or least stocked book. Customer & Order Management
List all customers from a specific country. Retrieve orders placed in a given date range. Identify customers who placed multiple orders. Show customers who spent more than a specified amount. Inventory & Sales Analysis
Calculate total stock of books available. Determine the most frequently ordered book. Compute total revenue from all orders. Find the total number of books sold per genre. Retrieve remaining stock after fulfilling all orders. Advanced Queries
Find the top-selling authors. Show the top 3 most expensive books in a genre. List cities where high-spending customers are located.
🛠Technologies Used PostgreSQL 17 (Compatible with other SQL databases) SQL Queries (SELECT, JOIN, GROUP BY, HAVING, ORDER BY, LIMIT)
📌 Future Enhancements Add Stored Procedures and Triggers for better database automation. Implement Views for simplified data retrieval. Integrate Indexes for faster query performance.