Online Bookstore SQL Project

Relational database analysis for a bookstore with 3 tables: Books, Customers, Orders.

Files

• SQL-project.sql: Schema + 20 queries (basic/advanced per brief)
• CSVs: Sample data used

Key Skills Demonstrated

• Table design with PK/FK
• Joins, GROUP BY, aggregates (SUM, AVG, COUNT)
• Filters (dates, genres, spend)
• Business insights: total revenue, top customers/books/genres

Sample Query Output Ideas

• Total revenue: ~$15K+ from orders
• Top genre sold: Check Fantasy vs others

Sample Results from Queries

Total Revenue (Query 11): $75,628.66

Top Genres by Books Sold (Query 12):

Genre	Quantity
Mystery	504
Science Fiction	447
Fantasy	446

Most Frequent Book (Query 15): Book_ID 73 - "Realigned multi-tasking installation" (28 units)