ecommerce-sql-project/data.sql at main · ruchi20788/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
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
insert into customersp values
(101, 'Amit Sharma', 'amit.sharma@gmail.com', 'Bangalore'),
(102, 'Priya Verma', 'priya.verma@yahoo.com', 'Mumbai'),
(103, 'Rahul Mehta', 'rahul.mehta@outlook.com', 'Delhi'),
(104, 'Sneha Reddy', 'sneha.reddy@gmail.com', 'Hyderabad'),
(105, 'Karan Patel', 'karan.patel@gmail.com', 'Ahmedabad'),
(106, 'Neha Singh', 'neha.singh@yahoo.com', 'Pune'),
(107, 'Arjun Nair', 'arjun.nair@outlook.com', 'Kochi'),
(108, 'Pooja Gupta', 'pooja.gupta@gmail.com', 'Jaipur'),
(109, 'Rohit Das', 'rohit.das@yahoo.com', 'Kolkata'),
(110, 'Ananya Iyer', 'ananya.iyer@gmail.com', 'Chennai');

insert into productsp values
(201, 'Laptop', 'Electronics', 65000.50000),
(202, 'Smartphone', 'Electronics', 25000.75000),
(203, 'Headphones', 'Accessories', 1500.99000),
(204, 'Office Chair', 'Furniture', 7000.25000),
(205, 'Water Bottle', 'Home & Kitchen', 350.50000),
(206, 'Backpack', 'Accessories', 1200.75000),
(207, 'Washing Machine', 'Appliances', 32000.00000),
(208, 'Microwave Oven', 'Appliances', 8500.60000),
(209, 'Running Shoes', 'Footwear', 4500.99000),
(210, 'Notebook Pack', 'Stationery', 250.25000),
(211, 'Tablet', 'Electronics', 18000.45000),
(212, 'Bluetooth Speaker', 'Electronics', 2200.99000),
(213, 'Desk Lamp', 'Furniture', 900.50000),
(214, 'Coffee Maker', 'Appliances', 5500.75000),
(215, 'Gaming Mouse', 'Accessories', 1800.30000),
(216, 'Keyboard', 'Accessories', 2500.00000),
(217, 'Air Fryer', 'Appliances', 7200.65000),
(218, 'Sofa Set', 'Furniture', 45000.00000),
(219, 'T-shirt', 'Clothing', 799.99000),
(220, 'Jeans', 'Clothing', 1999.50000);

insert into ordersp values
(301, '2025-01-05', 101),
(302, '2025-01-08', 102),
(303, '2025-01-10', 103),
(304, '2025-01-12', 104),
(305, '2025-01-15', 105),
(306, '2025-01-18', 106),
(307, '2025-01-20', 107),
(308, '2025-01-22', 108),
(309, '2025-01-25', 109),
(310, '2025-01-28', 110),
(311, '2025-02-01', 101),
(312, '2025-02-03', 103),
(313, '2025-02-05', 105),
(314, '2025-02-07', 107),
(315, '2025-02-10', 109);

insert into orderdetailssp values
(301, 201, 1),
(301, 203, 2),
(302, 202, 1),
(302, 205, 3),
(303, 204, 1),
(303, 206, 2),
(304, 207, 1),
(305, 208, 1),
(305, 209, 2),
(306, 210, 5),
(307, 211, 1),
(308, 212, 2),
(309, 213, 1),
(310, 214, 1),
(311, 215, 2),
(312, 216, 1),
(313, 217, 1),
(314, 218, 1),
(315, 219, 3),
(315, 220, 2);