ecommerce-sql-analytics/Insert.sql at main · gaurilingshetti/ecommerce-sql-analytics · GitHub

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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95

INSERT INTO customers VALUES
(1,'Amit Sharma','amit.sharma@gmail.com','Pune','2023-01-10'),
(2,'Neha Patil','neha.patil@gmail.com','Mumbai','2023-01-15'),
(3,'Rahul Verma','rahul.verma@gmail.com','Delhi','2023-01-20'),
(4,'Sneha Kulkarni','sneha.k@gmail.com','Pune','2023-02-05'),
(5,'Rohit Mehta','rohit.mehta@gmail.com','Bangalore','2023-02-12'),
(6,'Priya Singh','priya.singh@gmail.com','Lucknow','2023-02-18'),
(7,'Ankit Jain','ankit.jain@gmail.com','Indore','2023-03-01'),
(8,'Pooja Nair','pooja.nair@gmail.com','Kochi','2023-03-08'),
(9,'Karan Malhotra','karan.m@gmail.com','Delhi','2023-03-15'),
(10,'Riya Deshmukh','riya.d@gmail.com','Nagpur','2023-03-22'),
(11,'Suresh Iyer','suresh.i@gmail.com','Chennai','2023-04-01'),
(12,'Anjali Rao','anjali.rao@gmail.com','Hyderabad','2023-04-06'),
(13,'Vikram Joshi','vikram.j@gmail.com','Pune','2023-04-10'),
(14,'Meenal Gupta','meenal.g@gmail.com','Jaipur','2023-04-15'),
(15,'Arjun Kapoor','arjun.k@gmail.com','Mumbai','2023-04-20'),
(16,'Nikita Bansal','nikita.b@gmail.com','Noida','2023-05-01'),
(17,'Siddharth Mishra','sid.m@gmail.com','Bhopal','2023-05-05'),
(18,'Kavita Choudhary','kavita.c@gmail.com','Jodhpur','2023-05-10'),
(19,'Manish Pandey','manish.p@gmail.com','Kanpur','2023-05-15'),
(20,'Isha Roy','isha.roy@gmail.com','Kolkata','2023-05-20');

INSERT INTO products VALUES
(101,'Laptop','Electronics',55000),
(102,'Mobile Phone','Electronics',25000),
(103,'Bluetooth Headphones','Accessories',3000),
(104,'Office Chair','Furniture',7000),
(105,'Keyboard','Accessories',1500),
(106,'Mouse','Accessories',800),
(107,'Smart Watch','Electronics',12000),
(108,'Tablet','Electronics',30000),
(109,'Printer','Electronics',9000),
(110,'Router','Electronics',2500),
(111,'Desk Lamp','Furniture',1800),
(112,'Monitor','Electronics',14000),
(113,'Power Bank','Accessories',2000),
(114,'USB Cable','Accessories',500),
(115,'Backpack','Accessories',2200),
(116,'Gaming Chair','Furniture',15000),
(117,'Webcam','Electronics',3500),
(118,'External HDD','Electronics',6500),
(119,'Pen Drive','Accessories',900),
(120,'Wireless Earbuds','Electronics',4500);

INSERT INTO orders VALUES
(1001,1,'2023-06-01',58000),
(1002,2,'2023-06-03',25000),
(1003,3,'2023-06-05',3000),
(1004,4,'2023-06-08',7000),
(1005,5,'2023-06-10',56500),
(1006,6,'2023-06-12',12000),
(1007,7,'2023-06-15',1800),
(1008,8,'2023-06-18',30000),
(1009,9,'2023-06-20',9000),
(1010,10,'2023-06-22',2000),
(1011,11,'2023-07-01',14000),
(1012,12,'2023-07-03',2500),
(1013,13,'2023-07-05',2200),
(1014,14,'2023-07-08',15000),
(1015,15,'2023-07-10',3500),
(1016,16,'2023-07-12',6500),
(1017,17,'2023-07-15',900),
(1018,18,'2023-07-18',4500),
(1019,19,'2023-07-20',800),
(1020,20,'2023-07-22',12000);

INSERT INTO order_items VALUES
(1,1001,101,1,55000),
(2,1001,103,1,3000),
(3,1002,102,1,25000),
(4,1003,103,1,3000),
(5,1004,104,1,7000),
(6,1005,101,1,55000),
(7,1005,105,1,1500),
(8,1006,107,1,12000),
(9,1007,111,1,1800),
(10,1008,108,1,30000),
(11,1009,109,1,9000),
(12,1010,113,1,2000),
(13,1011,112,1,14000),
(14,1012,110,1,2500),
(15,1013,115,1,2200),
(16,1014,116,1,15000),
(17,1015,117,1,3500),
(18,1016,118,1,6500),
(19,1017,119,1,900),
(20,1018,120,1,4500),
(21,1019,106,1,800),
(22,1020,107,1,12000);

SELECT COUNT(*) FROM customers;
SELECT COUNT(*) FROM products;
SELECT COUNT(*) FROM orders;
SELECT COUNT(*) FROM order_items;