forked from bpo106/pallida-orientation-exam-retake
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathclothing.sql
43 lines (42 loc) · 2.55 KB
/
clothing.sql
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
CREATE TABLE warehouse(
id INT NOT NULL AUTO_INCREMENT,
item_name VARCHAR(80),
manufacturer VARCHAR(30),
category VARCHAR(30),
size VARCHAR(4),
unit_price FLOAT,
in_store INT,
PRIMARY KEY (id));
GO
INSERT INTO warehouse (item_name, manufacturer, category, size, unit_price)
VALUES
('Green Fox Jumper', 'Gucci', 'sweaters', 's', 80.00),
('Green Fox Jumper', 'Gucci', 'sweaters', 'm', 80.00),
('Half-Ip Ribbed Mock-Turtleneck Sweater', 'Polo Ralph Lauren', 'sweaters', 'l', 59.90),
('Green Fox Jumper', 'Gucci', 'sweaters', 'xxl', 80.00),
('Green Fox Short-Sleeved Mesh Polo Shirt', 'Ralph Lauren', 'shirts', 's', 60.50),
('Green Fox Short-Sleeved Mesh Polo Shirt', 'Ralph Lauren', 'shirts', 'm', 60.50),
('Wool/Alpaca Shawl Collar Cardigan', 'Bonnie Jean', 'sweaters', 'xl', 100.00),
('Green Fox Short-Sleeved Mesh Polo Shirt', 'Ralph Lauren', 'shirts', 'l', 60.50),
('Green Fox Short-Sleeved Mesh Polo Shirt', 'Ralph Lauren', 'shirts', 'xl', 60.50),
('Green Fox Jumper', 'Gucci', 'sweaters', 'l', 80.00),
('Green Fox Jumper', 'Gucci', 'sweaters', 'xl', 80.00),
('Green Fox Short-Sleeved Mesh Polo Shirt', 'Ralph Lauren', 'shirts', 's', 60.50),
('Two-Tone Sleeveless Sheath Dress', 'Nicole Miller', 'dresses', 'l', 69.90),
('Green Fox Short-Sleeved Mesh Polo Shirt', 'Ralph Lauren', 'shirts', 'm', 60.50),
('Green Fox Short-Sleeved Mesh Polo Shirt', 'Ralph Lauren', 'shirts', 'xl', 60.50),
('Strecth Steamed Pencil Skirt', 'Calvin Klein', 'skirts', 's', 39.00),
('Green Fox Short-Sleeved Mesh Polo Shirt', 'Ralph Lauren', 'shirts', 'l', 60.50),
('Strecth Steamed Pencil Skirt', 'Calvin Klein', 'skirts', 'm', 39.00),
('Half-Ip Ribbed Mock-Turtleneck Sweater', 'Polo Ralph Lauren', 'sweaters', 's', 59.90),
('Half-Ip Ribbed Mock-Turtleneck Sweater', 'Polo Ralph Lauren', 'sweaters', 'm', 59.90),
('Half-Ip Ribbed Mock-Turtleneck Sweater', 'Polo Ralph Lauren', 'sweaters', 'xxl', 59.90),
('Two-Tone Sleeveless Sheath Dress', 'Nicole Miller', 'dresses', 'xxl', 69.90),
('Two-Tone Sleeveless Sheath Dress', 'Nicole Miller', 'dresses', 'xl', 69.90),
('Two-Tone Sleeveless Sheath Dress', 'Nicole Miller', 'dresses', 's', 69.90),
('Wool/Alpaca Shawl Collar Cardigan', 'Bonnie Jean', 'sweaters', 's', 100.00),
('Half-Ip Ribbed Mock-Turtleneck Sweater', 'Polo Ralph Lauren', 'sweaters', 'xl', 59.90),
('Wool/Alpaca Shawl Collar Cardigan', 'Bonnie Jean', 'sweaters', 'm', 100.00),
('Wool/Alpaca Shawl Collar Cardigan', 'Bonnie Jean', 'sweaters', 'l', 100.00),
('Two-Tone Sleeveless Sheath Dress', 'Nicole Miller', 'dresses', 'm', 69.90),
('Wool/Alpaca Shawl Collar Cardigan', 'Bonnie Jean', 'sweaters', 'xxl', 100.00);