실습스키마

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

INSERT INTO vip_customers (customer_name, total_purchase) VALUES 
('Zoe', 18000), ('Julie', 20000);
 

CREATE TABLE products (
    product_name VARCHAR(100),
    price DECIMAL(10, 2),
    units_sold INT
);

INSERT INTO products (product_name, price, units_sold)
VALUES 
('Product A', 150, 50),
('Product B', 200, 30),
('Product C', 180, 40),
('Product D', 220, 35);