ecommerce_sql_project/2_insert_data.sql at main · aashishsaini30/ecommerce_sql_project · 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
INSERT INTO customers VALUES
(1, "Aashish", "Saini", "Rampur", "Uttar Pradesh", '2019-05-21'),
(2, "Vivek", "Rana", "Moradabad", "Uttar Pradesh", '2018-05-20'),
(3, "Monu", "Yadav", "Delhi", "Delhi", '2015-08-27'),
(4, "Dev", "Singh", "Mumbai", "Maharashtra", '2013-02-22'),
(5, "Harsh", "Saini", "Noida", "Uttar Pradesh", '2013-06-22'),
(6, "Ankit", "Sharma", "Delhi", "Delhi", '2021-03-15'),
(7, "Priya", "Mehta", "Jaipur", "Rajasthan", '2019-11-05'),
(8, "Neha", "Gupta", "Noida", "Uttar Pradesh", '2022-01-20'),
(9, "Rohit", "Kumar", "Patna", "Bihar", '2018-09-12'),
(10, "Simran", "Kaur", "Amritsar", "Punjab", '2020-12-25');

INSERT INTO products VALUES
(1, "Laptop", "Electronics", 50000.00),
(2, "Camera", "Electronics", 22000.00),
(3, "Shoes", "Fashion", 5000.00),
(4, "Shampoo", "Hair Care", 200.50),
(5, "Mobile", "Electronics", 15000.00),
(6, "Headphones", "Electronics", 2000.00),
(7, "T-shirt", "Fashion", 800.00),
(8, "Face Wash", "Skin Care", 300.00),
(9, "Watch", "Accessories", 2500.00),
(10, "Bag", "Fashion", 1200.00);

INSERT INTO orders VALUES
(101, 1, '2023-01-15', 50000.00),
(102, 2, '2023-02-10', 22000.00),
(103, 3, '2023-03-05', 5000.00),
(104, 4, '2023-04-12', 200.50),
(105, 5, '2023-05-10', 15000.00),
(106, 6, '2023-06-12', 2000.00),
(107, 7, '2023-07-01', 800.00),
(108, 8, '2023-08-18', 300.00),
(109, 1, '2023-09-10', 2000.00),
(110, 2, '2023-09-15', 5000.00);

INSERT INTO order_details VALUES
(1, 101, 1, 1, 50000.00),
(2, 102, 2, 1, 22000.00),
(3, 103, 3, 2, 10000.00),
(4, 104, 4, 5, 1002.50),
(5, 105, 5, 1, 15000.00),
(6, 106, 6, 2, 4000.00),
(7, 107, 7, 3, 2400.00),
(8, 108, 8, 1, 300.00),
(9, 109, 6, 1, 2000.00),
(10, 110, 3, 1, 5000.00);