-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsample_data.sql
More file actions
39 lines (37 loc) · 990 Bytes
/
sample_data.sql
File metadata and controls
39 lines (37 loc) · 990 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
INSERT INTO Customers VALUES
(1,'Ayushman Das','Delhi'),
(2,'Ritika Sharma','Mumbai'),
(3,'Kunal Roy','Kolkata'),
(4,'Aditya Verma','Bengaluru'),
(5,'Sneha Singh','Chennai'),
(6,'Manish Gupta','Pune');
INSERT INTO Products VALUES
(101,'Laptop',55000),
(102,'Mouse',799),
(103,'Keyboard',1299),
(104,'Smartphone',18999),
(105,'Headphones',2499),
(106,'Monitor 24-inch',9999),
(107,'USB-C Cable',399),
(108,'Bluetooth Speaker',3499);
INSERT INTO Sales VALUES
(1,1,101,1,'2025-01-03'),
(2,1,102,2,'2025-01-05'),
(3,1,107,3,'2025-01-07'),
(4,2,104,1,'2025-01-10'),
(5,2,105,1,'2025-01-11'),
(6,2,107,2,'2025-01-12'),
(7,3,103,1,'2025-01-14'),
(8,3,108,1,'2025-01-15'),
(9,3,102,1,'2025-01-18'),
(10,4,106,1,'2025-01-20'),
(11,4,101,1,'2025-01-22'),
(12,4,105,2,'2025-01-25'),
(13,5,104,1,'2025-01-27'),
(14,5,108,1,'2025-01-28'),
(15,5,107,5,'2025-01-29'),
(16,6,102,1,'2025-01-30'),
(17,6,103,1,'2025-02-01'),
(18,6,106,1,'2025-02-02'),
(19,6,105,1,'2025-02-05'),
(20,6,108,1,'2025-02-07');