Spaces:
Runtime error
Runtime error
File size: 572 Bytes
5f946b0 |
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 |
-- Table: transactions
CREATE TABLE transactions (
transaction_id INT PRIMARY KEY,
product_id INT,
product_name VARCHAR(100),
category VARCHAR(50),
quantity INT,
total_price DECIMAL(10, 2),
store_id INT,
date DATE
);
-- Table: returns
CREATE TABLE returns (
return_id INT PRIMARY KEY,
product_id INT,
product_name VARCHAR(100),
category VARCHAR(50),
store_id INT,
date DATE
);
-- Table: monthly_sales
CREATE TABLE monthly_sales (
product_id INT,
product_name VARCHAR(100),
month INT,
sales INT
);
|