실습스키마

CREATE TABLE customers ( 
    customer_name VARCHAR(100), 
    total_purchase DECIMAL(10, 2) 
); 

INSERT INTO customers (customer_name, total_purchase) VALUES 
('Alice', 12000), ('Bob', 8000), ('Charlie', 4500), ('David', 6000), ('Eva', 15000);

CREATE TABLE orders ( order_id INT, order_status VARCHAR(50) );

INSERT INTO orders (order_id, order_status) VALUES 
(101, 'Shipped'), (102, 'Pending'), (103, 'Shipped'), (104, 'Delivered'), (105, 'Pending');

CREATE TABLE projects ( 
    project_id INT PRIMARY KEY, 
    project_name VARCHAR(100), 
    employee_id INT 
);

INSERT INTO projects (project_id, project_name, employee_id) VALUES 
(1, 'Project Alpha', 1), (2, 'Project Beta', 2), (3, 'Project Gamma', 3), (4, 'Project Delta', NULL); 

CREATE TABLE orders ( 
    order_id INT PRIMARY KEY, 
    customer_name VARCHAR(50), 
    order_amount DECIMAL(10, 2) 
);

CREATE TABLE shipping_rates ( 
    rate_id INT PRIMARY KEY, 
    min_amount DECIMAL(10, 2), 
    max_amount DECIMAL(10, 2), 
    shipping_fee DECIMAL(10, 2) 
);


INSERT INTO orders_join (order_id, customer_name, order_amount)
VALUES
(1, 'Alice', 150.00),
(2, 'Bob', 75.00),
(3, 'Charlie', 300.00),
(4, 'David', 50.00),
(5, 'Eve', 200.00);

INSERT INTO shipping_rates (rate_id, min_amount, max_amount, shipping_fee)
VALUES
(1, 0.00, 100.00, 10.00),    -- 0 ~ 100 주문: 배송비 10
(2, 100.01, 200.00, 5.00),   -- 100.01 ~ 200 주문: 배송비 5
(3, 200.01, 500.00, 0.00);   -- 200.01 ~ 500 주문: 배송비 무료