sample_data.sql

USE OnlineBookStore;


INSERT INTO Customers (CustomerID, CustomerName, City, Email) VALUES
(1, 'Rahul Sharma', 'Hyderabad', 'rahul@gmail.com'),
(2, 'Sneha Reddy', 'Bangalore', 'sneha@gmail.com'),
(3, 'Arjun Kumar', 'Chennai', 'arjun@gmail.com'),
(4, 'Divya Patel', 'Mumbai', 'divya@gmail.com'),
(5, 'Priya Singh', 'Delhi', 'priya@gmail.com');


INSERT INTO Books (BookID, Title, Author, Genre, Price) VALUES
(101, 'Python Basics', 'John Smith', 'Programming', 499.00),
(102, 'SQL Mastery', 'David Lee', 'Database', 599.00),
(103, 'Java Programming', 'James Gosling', 'Programming', 699.00),
(104, 'Data Science Essentials', 'Andrew Ng', 'AI', 899.00),
(105, 'Web Development', 'Robert Martin', 'Web', 799.00);


INSERT INTO Orders (OrderID, CustomerID, BookID, Quantity, OrderDate) VALUES
(1001, 1, 101, 2, '2026-07-20'),
(1002, 2, 102, 1, '2026-07-21'),
(1003, 3, 104, 1, '2026-07-21'),
(1004, 1, 103, 1, '2026-07-22'),
(1005, 5, 105, 2, '2026-07-23'),
(1006, 4, 102, 3, '2026-07-24'),
(1007, 2, 105, 1, '2026-07-24');