CREATE TABLE orders (
    row_id INT,
    order_id VARCHAR(20),
    order_date DATE,
    ship_date DATE,
    ship_mode VARCHAR(20),
    customer_id VARCHAR(20),
    customer_name VARCHAR(50),
    segment VARCHAR(20),
    country_region VARCHAR(50),
    city VARCHAR(50),
    state VARCHAR(50),
    postal_code VARCHAR(10),
    region VARCHAR(20),
    product_id VARCHAR(20),
    category VARCHAR(30),
    sub_category VARCHAR(30),
    product_name VARCHAR(100),
    sales DECIMAL(10, 2),
    quantity INT,
    discount DECIMAL(3, 2),
    profit DECIMAL(10, 4)
);

INSERT INTO orders (row_id, order_id, order_date, ship_date, ship_mode, customer_id, customer_name, segment, country_region, city, state, postal_code, region, product_id, category, sub_category, product_name, sales, quantity, discount, profit) 
VALUES
(1, 'CA-2020-152156', '2020-11-08', '2020-11-11', 'Second Class', 'CG-12520', 'Claire Gute', 'Consumer', 'United States', 'Henderson', 'Kentucky', '42420', 'South', 'FUR-BO-10001798', 'Furniture', 'Bookcases', 'Bush Somerset Collection Bookcase', 261.96, 2, 0, 41.9136),
(2, 'CA-2020-152156', '2020-11-08', '2020-11-11', 'Second Class', 'CG-12520', 'Claire Gute', 'Consumer', 'United States', 'Henderson', 'Kentucky', '42420', 'South', 'FUR-CH-10000454', 'Furniture', 'Chairs', 'Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back', 731.94, 3, 0, 219.582),
(3, 'CA-2020-138688', '2020-06-12', '2020-06-16', 'Second Class', 'DV-13045', 'Darrin Van Huff', 'Corporate', 'United States', 'Los Angeles', 'California', '90036', 'West', 'OFF-LA-10000240', 'Office Supplies', 'Labels', 'Self-Adhesive Address Labels for Typewriters by Universal', 14.62, 2, 0, 6.8714),
(4, 'US-2019-108966', '2019-10-11', '2019-10-18', 'Standard Class', 'SO-20335', 'Sean ODonnell', 'Consumer', 'United States', 'Fort Lauderdale', 'Florida', '33311', 'South', 'FUR-TA-10000577', 'Furniture', 'Tables', 'Bretford CR4500 Series Slim Rectangular Table', 957.5775, 5, 0.45, -383.031),
(5, 'US-2019-108966', '2019-10-11', '2019-10-18', 'Standard Class', 'SO-20335', 'Sean ODonnell', 'Consumer', 'United States', 'Fort Lauderdale', 'Florida', '33311', 'South', 'OFF-ST-10000760', 'Office Supplies', 'Storage', 'Eldon Fold N Roll Cart System', 22.368, 2, 0.2, 2.5164),
(6, 'CA-2018-115812', '2018-06-09', '2018-06-14', 'Standard Class', 'BH-11710', 'Brosina Hoffman', 'Consumer', 'United States', 'Los Angeles', 'California', '90032', 'West', 'FUR-FU-10001487', 'Furniture', 'Furnishings', 'Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood', 48.86, 7, 0, 14.1694),
(7, 'CA-2018-115812', '2018-06-09', '2018-06-14', 'Standard Class', 'BH-11710', 'Brosina Hoffman', 'Consumer', 'United States', 'Los Angeles', 'California', '90032', 'West', 'OFF-AR-10002833', 'Office Supplies', 'Art', 'Newell 322', 7.28, 4, 0, 1.9656),
(8, 'CA-2018-115812', '2018-06-09', '2018-06-14', 'Standard Class', 'BH-11710', 'Brosina Hoffman', 'Consumer', 'United States', 'Los Angeles', 'California', '90032', 'West', 'TEC-PH-10002275', 'Technology', 'Phones', 'Mitel 5320 IP Phone VoIP phone', 907.152, 6, 0.2, 90.7152),
(9, 'CA-2018-115812', '2018-06-09', '2018-06-14', 'Standard Class', 'BH-11710', 'Brosina Hoffman', 'Consumer', 'United States', 'Los Angeles', 'California', '90032', 'West', 'OFF-BI-10003910', 'Office Supplies', 'Binders', 'DXL Angle-View Binders with Locking Rings by Samsill', 18.504, 3, 0.2, 5.7825),
(10, 'CA-2018-115812', '2018-06-09', '2018-06-14', 'Standard Class', 'BH-11710', 'Brosina Hoffman', 'Consumer', 'United States', 'Los Angeles', 'California', '90032', 'West', 'OFF-AP-10002892', 'Office Supplies', 'Appliances', 'Belkin F5C206VTEL 6 Outlet Surge', 114.9, 5, 0, 34.47),
(11, 'CA-2018-115812', '2018-06-09', '2018-06-14', 'Standard Class', 'BH-11710', 'Brosina Hoffman', 'Consumer', 'United States', 'Los Angeles', 'California', '90032', 'West', 'FUR-TA-10001539', 'Furniture', 'Tables', 'Chromcraft Rectangular Conference Tables', 1706.184, 9, 0.2, 85.3092),
(12, 'CA-2018-115812', '2018-06-09', '2018-06-14', 'Standard Class', 'BH-11710', 'Brosina Hoffman', 'Consumer', 'United States', 'Los Angeles', 'California', '90032', 'West', 'TEC-PH-10002033', 'Technology', 'Phones', 'Konftel 250 Conference phone - Charcoal black', 911.424, 4, 0.2, 68.3568),
(13, 'CA-2021-114412', '2021-04-15', '2021-04-20', 'Standard Class', 'AA-10480', 'Andrew Allen', 'Consumer', 'United States', 'Concord', 'North Carolina', '28027', 'South', 'OFF-PA-10002365', 'Office Supplies', 'Paper', 'Xerox 1967', 15.552, 3, 0.2, 5.4432),
(14, 'CA-2020-161389', '2020-12-05', '2020-12-10', 'Standard Class', 'IM-15070', 'Irene Maddox', 'Consumer', 'United States', 'Seattle', 'Washington', '98103', 'West', 'OFF-BI-10003656', 'Office Supplies', 'Binders', 'Fellowes PB200 Plastic Comb Binding Machine', 407.976, 3, 0.2, 132.5922),
(15, 'US-2019-118983', '2019-11-22', '2019-11-26', 'Standard Class', 'HP-14815', 'Harold Pawlan', 'Home Office', 'United States', 'Fort Worth', 'Texas', '76106', 'Central', 'OFF-AP-10002311', 'Office Supplies', 'Appliances', 'Holmes Replacement Filter for HEPA Air Cleaner, Very Large Room, HEPA Filter', 68.81, 5, 0.8, -123.858),
(16, 'US-2019-118983', '2019-11-22', '2019-11-26', 'Standard Class', 'HP-14815', 'Harold Pawlan', 'Home Office', 'United States', 'Fort Worth', 'Texas', '76106', 'Central', 'OFF-BI-10000756', 'Office Supplies', 'Binders', 'Storex DuraTech Recycled Plastic Frosted Binders', 2.544, 3, 0.8, -3.816)



select * from orders;