create_table.sql

Project objective:

E commerce platform customer behaviour analysis
To find Sales, revenue, order, products, customers insights
SQL skills (SELECT, JOIN, GROUP BY, HAVING, Subquery)showcase


customer table

CREATE TABLE customer( 
		customer_id INT PRIMARY KEY,
		customer_name VARCHAR(100),
		city VARCHAR(50),
		signup_date DATE
		);
		

products table

CREATE TABLE products (
			products_id INT PRIMARY KEY,
			product_name VARCHAR(100),
			category VARCHAR(50),
			price DECIMAL(10,2)
	);
			
			


orders table

CREATE TABLE orders(
		order_id INT PRIMARY KEY,
		customer_id INT,
		order_date DATE,
		FOREIGN KEY (customer_id) REFERENCES
	customers(customer_id)
);



orders_items table

CREATE TABLE order_items(
	order_item_id INT PRIMARY KEY,
	order_id INT,
	product_id INT,
	quantity INT,
	FOREIGN KEY (order_id) REFERENCES 
 orders(order_id),
	FOREIGN KEY (product_id) REFERENCES
products(product_id));