CREATE TABLE products (
product_id INT,
product_name VARCHAR(100),
category VARCHAR(50),
price DECIMAL(10, 2),
stock_quantity INT
);
INSERT INTO products (product_id, product_name, category, price, stock_quantity)
VALUES
(1, 'Smartphone', 'Electronics', 599.99, 100),
(2, 'Laptop', 'Electronics', 999.99, 50),
(3, 'Headphones', 'Electronics', 99.99, 200),
(4, 'T-shirt', 'Apparel', 19.99, 300),
(5, 'Jeans', 'Apparel', 49.99, 150);