Data+Modelling+V2.sql

-- Creating a data base
CREATE DATABASE RETAIL_DB;

-- Dropping a database
DROP DATABASE RETAIL_DB;

-- USE THE DATABASE
USE RETAIL_DB;

-- CREATING SALES FACT
CREATE TABLE SALES_FACT
(
	ORDER_ID INT PRIMARY KEY,
    CUSTOMER_ID INT NOT NULL,
    ORDER_DATE DATE,
    STORE_ID SMALLINT
);

# DROP TABLE SALES_FACT;
 # -- DIFFERENT APPROACH ON PRIMARY KEY
# CREATE TABLE SALES_FACT
#(
#	ORDER_ID INT,
 #   CUSTOMER_ID INT NOT NULL,
  #  ORDER_DATE DATE,
   # STORE_ID SMALLINT,
    #PRIMARY KEY (ORDER_ID)
# );


-- CREATING ORDER_PRODUCT_MAPPING TABLE
CREATE TABLE ORDER_PRODUCT_MAPPING
(
 ORDER_ID INT,
 PRODUCT_ID VARCHAR(10),
 QUANTITY_ORDERED INT
);

ALTER TABLE ORDER_PRODUCT_MAPPING
ADD PRIMARY KEY (ORDER_ID, PRODUCT_ID);

-- CREATING PRODUCT_INFO
CREATE TABLE PRODUCT_INFO
(
product_id	varchar(10) PRIMARY KEY,
product_name varchar(100),
product_category	varchar(50),
list_price	decimal(12,2),
sale_price	decimal(12,2)
);

-- CREATING CUSTOMER_INFO
CREATE TABLE CUSTOMER_INFO
(
customer_id	int PRIMARY KEY ,
first_name	varchar(20) ,
last_name	varchar(20) ,
gender	varchar(10) ,
email	varchar(30)
);

-- CREATING BRANCH_DETAILS
CREATE TABLE BRANCH_DETAILS(
store_id smallint  PRIMARY KEY,
store_name	varchar(20),
area	varchar(20),
city	varchar(20),
state	varchar(20)
);

-- ADDING FOREIGN KEY CONSTRAINT

ALTER TABLE SALES_FACT
ADD CONSTRAINT ORDER_ID_fn
	FOREIGN KEY (ORDER_ID) REFERENCES ORDER_PRODUCT_MAPPING(ORDER_ID);

ALTER TABLE ORDER_PRODUCT_MAPPING
ADD CONSTRAINT FOREIGN KEY (PRODUCT_ID) REFERENCES PRODUCT_INFO(PRODUCT_ID);

ALTER TABLE SALES_FACT
ADD CONSTRAINT FOREIGN KEY (CUSTOMER_ID) REFERENCES CUSTOMER_INFO(CUSTOMER_ID);

ALTER TABLE SALES_FACT
ADD CONSTRAINT FOREIGN KEY (store_id) REFERENCES BRANCH_DETAILS(store_id);

#--------------------------------------------------------------------------

-- Loading data into CUSTOMER_INFO-- INSERTING RECORDS INTO CUSTOMER_INFO

INSERT INTO CUSTOMER_INFO
VALUES
(100,'Rohini','Krishnan','female','rohinan@gmail.com'),
(101,'Padmini','Boase','female','padminase@gmail.com'),
(102,'Naresh','Dhillon','male','nareon@gmail.com'),
(103,'Arun','Narine','male','arunnaine@gmail.com'),
(104,'Darpan','Brar','male','darprar@gmail.com'),
(105,'Devika','Swamy','female','devikmy@gmail.com'),
(106,'Aayushi','Narang','female','aayushang@gmail.com'),
(107,'Anand','Sandal','male','anandal@gmail.com'),
(108,'Yadunandan','Master','male','yadunater@gmail.com'),
(109,'Julie','Ravel','female','julivel@gmail.com'),
(110,'Zaad','Joshi','male','zaadjoshi@gmail.com'),
(111,'Manjari','Rana','female','manjaana@gmail.com'),
(112,'Nutan','Uppal','female','nutaal@gmail.com'),
(113,'Bhaagyasree','Varma','female','bhaama@gmail.com'),
(114,'Jagdish','Soman','male','jagdan@gmail.com'),
(115,'Aatif','Edwin','male','aatiin@gmail.com'),
(116,'Owais','Bakshi','male','owaisshi@gmail.com'),
(117,'Hema','Jhaveri','female','hemajri@gmail.com'),
(118,'Balaji','Sachar','male','balaar@gmail.com'),
(119,'Kushal','Sachdev','male','kushdev@gmail.com'),
(120,'Umar','Hans','male','umarhans@gmail.com'),
(121,'Mowgli','Matthai','male','mowglai@gmail.com'),
(122,'Gaurav','Pandit','male','gaurdit@gmail.com'),
(123,'Yadu','Chaudhuri','male','yaduchuri@gmail.com'),
(124,'Bagwati','Pai','female','bagwai@gmail.com'),
(125,'Jack','Bedi','male','jackedi@gmail.com'),
(126,'Parveen','Ramaswamy','male','parveemy@gmail.com'),
(127,'Baldev','Dube','male','baldbe@gmail.com'),
(128,'Himesh','Ramson','male','himeon@gmail.com'),
(129,'Hema','Purohit','female','hemapit@gmail.com'),
(130,'Sameera','Tak','female','sametak@gmail.com'),
(131,'Sara','Sule','female','sarasuule@gmail.com'),
(132,'Yadu','Balasubramanian','male','yaduban@gmail.com'),
(133,'Mohan','Koshy','male','mohankhy@gmail.com'),
(134,'Madhavi','Sidhu','female','madhavhu@gmail.com'),
(135,'Narayan','Brar','male','narayaar@gmail.com'),
(136,'Binoya','Mittal','male','binoyal@gmail.com'),
(137,'Albert','Menon','male','albernon@gmail.com'),
(138,'Bahadur','Sodhani','male','bahaduni@gmail.com'),
(139,'Bimla','Cherian','female','bimlacian@gmail.com'),
(140,'Biren','Parikh','male','birenkh@gmail.com'),
(141,'Nidhi','Chaudhari','female','nidhicari@gmail.com'),
(142,'Yadunandan','Choudhry','male','yadunary@gmail.com'),
(143,'Manpreet','Mallick','male','manpick@gmail.com'),
(144,'Dinesh','Gour','male','dinesur@gmail.com'),
(145,'Bhairavi','Hegde','female','bhairagde@gmail.com'),
(146,'Astha','Madan','female','asthan@gmail.com'),
(147,'Mahmood','Malpani','male','mahmooani@gmail.com'),
(148,'Leelawati','Sharma','female','leelawrma@gmail.com'),
(149,'Narayan','Rao','male','narayaao@gmail.com'),
(150,'Mustafa','Mital','male','mustafal@gmail.com'),
(151,'Astha','Merchant','female','asthamant@gmail.com'),
(152,'Niyati','Dhawan','female','niyatian@gmail.com'),
(153,'Yadunandan','Dugal','male','yadunal@gmail.com'),
(154,'Arvind','Krish','male','arvinsh@gmail.com'),
(155,'Bimla','Parmer','female','bimlamer@gmail.com'),
(156,'Pamela','Sarkar','female','pamelkar@gmail.com'),
(157,'Somnath','Mahabir','male','somnatbir@gmail.com'),
(158,'Raju','De','male','rajuude@gmail.com'),
(159,'Aabha','Sankar','female','aabhkar@gmail.com'),
(160,'Radheshyam','Nigam','male','radhegam@gmail.com'),
(161,'Lakshmi','Varkey','male','laksey@gmail.com'),
(162,'Vijayent','Kata','male','vijayeata@gmail.com'),
(163,'Nishita','Kari','female','nishitari@gmail.com'),
(164,'Moti','Kothari','male','motiari@gmail.com'),
(165,'Lalita','Hayer','female','laliter@gmail.com'),
(166,'John','Goyal','male','johnyal@gmail.com'),
(167,'Nazir','Lad','male','nazirlad@gmail.com'),
(168,'Himani','Bhatt','female','himantt@gmail.com'),
(169,'Moti','Wable','male','motiwale@gmail.com'),
(170,'Nawab,','Wali','male','nawabwali@gmail.com'),
(171,'Satish','Sethi','male','satihi@gmail.com'),
(172,'Diya','Vyas','female','diyaas@gmail.com'),
(173,'Radheshyam','Kanda','male','radhnda@gmail.com'),
(174,'Aatif','Dar','male','aatidar@gmail.com'),
(175,'Nandini','Chhabra','female','nandira@gmail.com'),
(176,'Ajeet','Dial','male','ajeetial@gmail.com'),
(177,'Dhanush','Chatterjee','male','dhanjee@gmail.com'),
(178,'Govind','Kata','male','goviata@gmail.com'),
(179,'Aslam','Upadhyay','male','aslamuyay@gmail.com'),
(180,'Leelawati','Seshadri','female','leelri@gmail.com'),
(181,'Jack','Dutta','male','jacktta@gmail.com'),
(182,'Namita','Bakshi','female','namishi@gmail.com'),
(183,'Zara','Mehan','female','zaramean@gmail.com'),
(184,'David','Parsa','male','davirsa@gmail.com'),
(185,'Aatif','Bose','male','aatifbse@gmail.com'),
(186,'Arun','Chana','male','arunchna@gmail.com'),
(187,'Vikrant','Shankar','male','vikrkar@gmail.com'),
(188,'Munni','Shetty','female','munnisty@gmail.com'),
(189,'Himesh','Tara','male','himeara@gmail.com'),
(190,'Shanti','Dhar','female','shanar@gmail.com'),
(191,'Bijoy','Maraj','male','bijoraj@gmail.com'),
(192,'Vimala','Kapadia','female','vimaladia@gmail.com'),
(193,'Akhil','Sathe','male','akhilsthe@gmail.com'),
(194,'Aayushman','Khan','male','aayuhan@gmail.com'),
(195,'Obaid','Taneja','male','obaidteja@gmail.com'),
(196,'Ram','Dash','male','ramdassh@gmail.com'),
(197,'Ananya','Pillay','female','ananlay@gmail.com'),
(198,'Mehul','Vora','male','mehura@gmail.com'),
(199,'Mahmood','Gola','male','mahmola@gmail.com'),
(200,'Fakaruddin','Tripathi','male','fakarthi@gmail.com');

#----------CALCULATION OF TOTAL ROWS ENTERED TO CROSS CHECK ACCURACY
select COUNT(*) FROM CUSTOMER_INFO ;

#___________________________________________________________________________________


-- Loading data into BRANCH_DETAILS-- INSERTING RECORDS INTO BRANCH_DETAILS

INSERT INTO BRANCH_DETAILS VALUES
(1,'Store A','Koramangala','Bengaluru','Karnataka'),
(2,'Store A','Indiranagar','Bengaluru','Karnataka'),
(3,'Store A','Jayanagar','Bengaluru','Karnataka'),
(4,'Store A','Andheri','Mumbai','Maharashtra'),
(5,'Store A','Bandra','Mumbai','Maharashtra'),
(6,'Store A','DLF Phase 3','Gurgaon','Haryana'),
(7,'Store B','Indiranagar','Bengaluru','Karnataka'),
(8,'Store B','Marathalli','Bengaluru','Karnataka'),
(9,'Store B','South City','Gurgaon','Haryana'),
(10,'Store B','Andheri','Mumbai','Maharashtra');

#----------CALCULATION OF TOTAL ROWS ENTERED TO CROSS CHECK ACCURACY
SELECT COUNT(*) FROM BRANCH_DETAILS;
#___________________________________________________________________________________

-- Loading data into PRODUCT_INFO-- INSERTING RECORDS INTO PRODUCT_INFO

INSERT INTO PRODUCT_INFO VALUES
('111a','Gooseberry (Amla)','fresh fruits',130,130),
('1220','Parachute Advanced Aloe Vera Coconut Hair Oil','hair and body oils',39,39),
('137b','French Beans (Phaliyaan)','fresh vegetables',16,16),
('139c','Washington Apple (Seb)','fresh fruits',260,260),
('13e6','Lux Saffron Glow Soap ','soaps and bodywash',108,108),
('1432','Nestle A+ Slim Skimmed Milk ','milk',80,80),
('146a','Cornitos Tikka Masala Nacho Crisps','chips nachos and popcorn',35,35),
('173c','Parachute Pure Coconut Oil ','hair and body oils',39,39),
('176f','Britannia Nutri Choice Hi-Fibre Digestive Biscuits','biscuits',159,159),
('17bf','Tropicana Pineapple Delight Juice (Tetra Pack)','soft drinks-juice and soda',100,100),
('184e','Tata Iodised Crystal Salt','salt',18,18),
('1874','Snickers Almond Chocolate','chocolate',25,25),
('1880','Bajji Green Chilli (Pakora Mirch)','fresh vegetables',69,69),
('188e','Nilgiris Premium Long Grain Pulao Rice','rice_rice_products',75,75),
('1963','Nilgiris Premium Methi Seeds','masala and spice',25,25),
('1a9f','Nilgiris Premium Green Chana','pulses and other grains',78,78),
('1aac','Nivea Oil Control Face Wash for Men','face wash',175,175),
('1ade','Nilgiris Premium Groundnuts','pulses and other grains',35,27),
('1c15','Britannia Treat Crazy Pineapple Cream Biscuits ','biscuits',30,30),
('1c3d','Baby Corn (Makkai)','fresh vegetables',90,90),
('1d70','Nilgiris Premium Fine Sooji ','atta and other flours',65,65),
('1df8','Garnier Skin Naturals Light Complete Fairness Face Wash','face wash',170,170),
('1e5e','Chinese Cabbage (Patha Gobi)','fresh vegetables',60,60),
('200b','Fogg Nepoleon Fragrance Body Spray for Men ','deodorants',230,230),
('2249','Nilgiris Premium Black Masoor Dal','pulses and other grains',43,43),
('237a','Parle Milano Center Filled Mixed Berries Cookies','biscuits',35,35),
('2406','Yellow Pumpkin (Kaddoo)','fresh vegetables',44,44),
('2499','Brooke Bond 3 Roses Tea','tea',50,50),
('251d','Nilgiris Premium American Green Peas','pulses and other grains',27,27),
('25bd','Organic India Tulsi Masala Flavoured Tea','tea',230,230),
('263e','Palmolive Thermal Spa Body Gel','soaps and bodywash',180,180),
('27c3','Green Pumpkin (Kaddoo)','fresh vegetables',38,38),
('28d5','Colgate Strong Teeth Toothpaste Combo','toothpaste',184,184),
('2a73','Nilgiris Premium Cloves','masala and spice',169,150),
('2bc0','Snickers Chocolate','chocolate',35,35),
('2e2e','Britannia Nutrichoice Simply Lite Crackers ','biscuits',15,15),
('2ed1','Nilgiris Delight Toned Milk','milk',20,20),
('3111','Cherry','fresh fruits',495,495),
('3128','Paper Boat Jaljeera Juice (Tetra Pack)','soft drinks-juice and soda',30,30),
('31c8','Nilgiris Premium Small Sago','pulses and other grains',62,62),
('32f7','Parle-G Glucose Biscuits ','biscuits',20,20),
('35af','Organic India Tulsi Ginger Tea (Tea Bags)','tea',148,148),
('3690','Coca-Cola Diet Coke (Can)','soft drinks-juice and soda',45,45),
('37ab','Yellow Capsicum (Shimla Mirch)','fresh vegetables',250,250),
('3995','Nilgiris Premium Fried Gram - Split','pulses and other grains',65,65),
('3a6a','Yellow Zucchini','fresh vegetables',60,60),
('3a70','Parle Hide & Seek Black Bourbon Choco Crème Sandwich Biscuits','biscuits',30,30),
('3b82','Purple Brinjal (Baingan)','fresh vegetables',110,110),
('3d5a','B Natural Cloudy Apple Juice (Tetra Pack)','soft drinks-juice and soda',99,99),
('3e09','Nilgiris Premium Nylon Sago - Grain','pulses and other grains',24,24),
('3f4c','Dabur Squeezy Honey - Buy 1 Get 1 Free','honey',280,280),
('3f89','Muskmelon (Kharbooja)','fresh fruits',45,45),
('4012','Sunfeast Marie Light Orange Biscuits ','biscuits',15,15),
('4071','Tata Lite Low Sodium Iodised Salt','salt',35,35),
('408f','Nilgiris Tea Crackers','biscuits',35,35),
('4243','Medium Onion (Pyaaz)','fresh vegetables',130,130),
('430f','Cherry Tomato (Tamatar)','fresh vegetables',44,44),
('4323','Cornitos Sizzlin Jalapeno Nachos','chips nachos and popcorn',85,82),
('4431','Britannia Marie Gold Biscuits ','biscuits',10,10),
('44a8','Nilgiris Premium Chana Dal - Split','pulses and other grains',95,95),
('4796','Nilgiris Premium Diamond White Sugar','sugar',13,13),
('486a','Tropicana Slice Mango Juice (Tetra Pack)','soft drinks-juice and soda',65,65),
('4873','Schweppes Indian Tonic Water (Can)','soft drinks-juice and soda',50,37),
('488d','Sunfeast Bounce Tangy Orange Cream Biscuits ','biscuits',10,10),
('4925','Spinach (Palak)','fresh vegetables',15,15),
('4ace','Tropicana Pomegranate Delight Juice (Tetra Pack)','soft drinks-juice and soda',110,110),
('4afc','Cowpea Beans (Phaliyaan)','fresh vegetables',60,60),
('4b18','Dev Snacks Banana Chips','chips nachos and popcorn',85,85),
('4cc9','Peeled Onion (Pyaaz)','fresh vegetables',20,20),
('4f27','Nilgiris Premium Navratan Dal Mix','pulses and other grains',68,68),
('4fe4','Robusta Banana (Kela)','fresh fruits',98,98),
('50b5','Small Broad Beans','fresh vegetables',50,50),
('51b5','Garlic (Lahsun)','fresh vegetables',41,41),
('535c','Nilgiris Premium White Urad Dal','pulses and other grains',27,27),
('551f','Nilgiris Premium Black Jeera Seeds','masala and spice',33,33),
('559f','Banana Flower (Kele Ka Phool)','fresh vegetables',20,20),
('5744','Colgate Herbal Toothpaste','toothpaste',88,88),
('58a5','Minute Maid Pulpy Mosambi Juice (Bottle)','soft drinks-juice and soda',75,75),
('595c','Organic India Original Tulsi Tea (Tea Bags)','tea',148,148),
('5a9d','Nilgiris Premium White Urad Dal - Split','pulses and other grains',116,116),
('5ce1','Kinnow Orange (Santara)','fresh fruits',53,53),
('5e70','Palmolive Aroma Absolute Relax Body Gel','soaps and bodywash',180,180),
('601d','Pringles South African Style Peri Peri Potato Crisps','chips nachos and popcorn',99,99),
('6601','Yelakki Banana (Kela)','fresh fruits',53,53),
('66c8','Cadbury Dairy Milk Roast Almond Chocolate','chocolate',40,40),
('67e8','Nilgiris Premium White Peas','pulses and other grains',51,51),
('687b','Tropicana Slice Mango Juice (Bottle)','soft drinks-juice and soda',50,50),
('6953','Raw Mango (Kaccha Aam)','fresh vegetables',40,40),
('6996','Red Carrot (Gajar)','fresh vegetables',80,80),
('6b27','B Natural Orange Juice (Tetra Pack)','soft drinks-juice and soda',99,99),
('6b46','Kashmir Apple (Seb)','fresh fruits',90,90),
('6c70','Lemongrass','fresh vegetables',35,35),
('6d03','Aashirvaad Superior MP Atta ','atta and other flours',55,55),
('6d5d','Cadbury 5 Star 3D Chocolate','chocolate',30,30),
('6d94','Nilgiris Premium Bay Leaf','masala and spice',10,10),
('6e9b','Raw Papaya (Kaccha Papita)','fresh vegetables',38,38),
('71c2','Cauliflower (Phool Gobi)','fresh vegetables',40,40),
('7308','Senai Yam (Rataloo)','fresh vegetables',35,35),
('733b','Nilgiris Good to Snack Rusk','biscuits',15,15),
('740f','Beetroot (Chukandar)','fresh vegetables',40,40),
('74b8','Nivea Men Dark Spot Reduction Face Wash','face wash',199,199),
('74dd','Parle Krack Jack Sweet & Salty Crackers','biscuits',10,10),
('755b','Britannia Good Day Chocochip Cookies ','biscuits',30,30),
('7628','Indian Seedless Green Grapes (Angoor)','fresh fruits',60,60),
('7713','Nilgiris Premium Butter Beans','pulses and other grains',74,74),
('77c1','Long Purple Brinjal (Baingan)','fresh vegetables',35,35),
('780d','Green Zucchini','fresh vegetables',234,234),
('78fb','Aashirvaad Select Sharbati Atta','atta and other flours',255,255),
('7ecd','Leeks','fresh vegetables',18,18),
('7edd','Nestle Milkybar Moosha Chocolate','chocolate',20,20),
('7f5b','Dettol Original Hand Wash Refill','hand wash',58,58),
('80d8','Nilgiris Premium Clove/Laung Powder','masala and spice',60,60),
('8146','Colgate Vedshakti Toothpaste ','toothpaste',49,49),
('81ab','Parle Real Elaichi Premium Rusk','biscuits',30,30),
('827e','English Cucumber (Kheera)','fresh vegetables',25,25),
('8460','Nilgiris Toned Milk','milk',20,20),
('8526','Peppy Sumo Pack Cheese Balls','chips nachos and popcorn',50,50),
('85ca','Britannia Milk Bikis Sandwich Biscuits ','biscuits',40,40),
('85d3','Tomato (Tamatar)','fresh vegetables',26,26),
('8605','Ash Gourd (Petha)','fresh vegetables',35,35),
('863c','Nilgiris Sona Masoori Premium Rice','rice_rice_products',335,335),
('86ec','Pomegranate (Anaar)','fresh fruits',162,162),
('8905','Iceberg Lettuce','fresh vegetables',120,120),
('89c3','Nilgiris Premium Horse Gram','pulses and other grains',18,15),
('8a43','Britannia Treat Funky Choco Biscuits','biscuits',30,30),
('8a61','Sensodyne Whitening Toothpaste','toothpaste',115,115),
('8b29','Doritos Cheese Nachos','chips nachos and popcorn',65,65),
('8b66','Cornitos Sizzlin Jalapeno Nacho Crisps','chips nachos and popcorn',35,35),
('8bed','Nilgiris Premium Kolam Rice','rice_rice_products',460,460),
('8d0b','Himalaya Aloe Vera Moisturizing Face Wash ','face wash',120,120),
('8dbb','Nilgiris Premium Gram Flour ','atta and other flours',54,45),
('8fd1','Avocado','fresh fruits',570,570),
('9055','Pantene Total Damage Care Shampoo ','shampoo',220,220),
('90b0','Britannia Nutrichoice Essentials Oat Cookies','biscuits',60,60),
('9253','Britannia Pure Magic Choco Creme Biscuits','biscuits',30,30),
('92c5','Britannia Treat Burst Choco Cream Fills Cookies','biscuits',15,15),
('92c6','Thums Up Charged (Can)','soft drinks-juice and soda',35,35),
('93c8','Britannia Milk Bikis Biscuits','biscuits',25,25),
('93d8','Nilgiris Premium Black Urad - Split','pulses and other grains',115,115),
('949a','Green Capsicum (Shimla Mirch)','fresh vegetables',80,80),
('94c5','Sweet Lime (Mosambi)','fresh fruits',105,105),
('94e2','Herbs and Seasonings Combo','fresh vegetables',85,85),
('9695','Sunfeast Glucose Biscuits ','biscuits',10,10),
('9701','Carrot (Gajar)','fresh vegetables',54,54),
('98e7','Green Raw Banana (Kaccha Kela)','fresh vegetables',12,12),
('9b60','Cadbury 5 Star Chocolate','chocolate',20,20),
('9bff','Banana Stem','fresh vegetables',20,20),
('9d4a','Mysore Sandal  Soap ','soaps and bodywash',62,62),
('9d8d','Nilgiris Premium Thick Regular Beaten Rice','rice_rice_products',35,35),
('1170','Dabur Honey ','honey',37,37),
('1252','Kurkure Shahi Twistkeen Crisps','chips nachos and popcorn',35,35),
('140d','Asparagus (Shatavari)','fresh vegetables',375,375),
('16c9','Himalaya Neem & Turmeric Soap ','soaps and bodywash',45,45),
('16f5','Britannia Toastea Multigrain Rusk','biscuits',35,35),
('172f','Cornitos Cheese and Herb Nachos','chips nachos and popcorn',85,85),
('17e1','Gone Mad Sugar Cheese Crackers ','biscuits',60,60),
('1982','Nilgiris Premium Hamsa Rice (Medium Grain)','rice_rice_products',44,38),
('1a62','Garnier Oil Clear Gel Face Wash For Men','face wash',195,195),
('1b6b','Brooke Bond Red Label Natural Care Tea','tea',130,130),
('1d42','Strawberry','fresh fruits',95,95),
('1d51','Fanta (Bottle)','soft drinks-juice and soda',40,40),
('1f44','Nilgiris Premium Yellow Mustard Seeds','masala and spice',20,20),
('1f8b','Long Green Brinjal (Baingan)','fresh vegetables',100,100),
('2116','Parle Premium Real Elaichi Rusk','biscuits',57,47),
('223a','Parle-G Gold Glucose Biscuits ','biscuits',100,100),
('2459','Nilgiris Spicy Cracker','biscuits',40,40),
('28a9','Nilgiris Premium Black Urad Dal','pulses and other grains',58,58),
('28c6','Nilgiris Premium Dry Ginger','masala and spice',60,60),
('29ba','Onion (Payaaz)','fresh vegetables',145,145),
('29ec','Chinese Cabbage (Patta Gobi)','fresh vegetables',35,28),
('2a00','Bitter Gourd (Karela)','fresh vegetables',46,46),
('2c1c','Bingo Mad Angles Masala Crisps','chips nachos and popcorn',20,20),
('2da0','MDH Deggi Mirch Powder','masala and spice',60,60),
('3577','Nilgiris Premium Bajra - Seeds','pulses and other grains',32,28),
('395e','Nilgiris Premium Country Sugar','sugar',45,45),
('39c3','Real Fruit Power Activ 100% Orange Juice (Tetra Pack)','soft drinks-juice and soda',130,130),
('3a7a','Nilgiris Premium Soya Chunks','pulses and other grains',26,26),
('3b21','Litchi','fresh fruits',230,166),
('3f49','Real Fruit Power Litchi Juice (Tetra Pack)','soft drinks-juice and soda',105,105),
('4362','Biotique Advanced Fairness Face Wash','face wash',100,91),
('45f8','Britannia Good Day Chunkies Chocolate Chip Cookies','biscuits',50,50),
('46ab','Thums Up (Can)','soft drinks-juice and soda',35,35),
('47e4','Parle Monaco Cheeslings Classic Crackers ','biscuits',120,120),
('4ec8','Nilgiris Premium Bajra Flour ','atta and other flours',35,35),
('5262','Raspberry','fresh fruits',780,780),
('52dc','Cabbage (Patta Gobi)','fresh vegetables',30,30),
('5446','Mogu Mogu Mango Juice (Bottle)','soft drinks-juice and soda',60,60),
('55d7','Coca-Cola (Bottle)','soft drinks-juice and soda',80,80);

SELECT COUNT(*) AS TOTAL_ROWS FROM PRODUCT_INFO;

#_____________________________________________________________________________________

-- Loading data into ORDER_PRODUCT_MAPPING-- INSERTING RECORDS INTO ORDER_PRODUCT_MAPPING

INSERT INTO ORDER_PRODUCT_MAPPING VALUES
(1000,'7713',6),
(1001,'3690',3),
(1001,'4925',8),
(1001,'7713',5),
(1001,'74dd',3),
(1002,'601d',4),
(1002,'3a70',6),
(1002,'173c',2),
(1003,'3a70',10),
(1004,'3f89',3),
(1004,'58a5',10),
(1005,'3a6a',10),
(1005,'200b',8),
(1005,'85ca',6),
(1006,'2249',2),
(1007,'6b46',7),
(1008,'8526',10),
(1008,'780d',2),
(1008,'1df8',10),
(1009,'173c',6),
(1009,'37ab',6),
(1009,'2249',10),
(1009,'2bc0',7),
(1010,'66c8',4),
(1011,'85ca',1),
(1011,'6b27',9),
(1012,'7edd',10),
(1013,'92c6',1),
(1013,'8460',7),
(1013,'949a',5),
(1013,'98e7',5),
(1014,'949a',4),
(1015,'92c5',6),
(1015,'172f',8),
(1016,'85ca',1),
(1016,'16f5',1),
(1016,'31c8',8),
(1016,'93c8',9),
(1017,'74b8',4),
(1017,'94e2',7),
(1017,'173c',1),
(1017,'17bf',4),
(1017,'780d',1),
(1017,'1982',2),
(1017,'2499',9),
(1018,'50b5',9),
(1019,'81ab',6),
(1019,'188e',9),
(1019,'90b0',9),
(1019,'1432',6),
(1020,'4873',6),
(1021,'67e8',8),
(1022,'3690',6),
(1023,'8b66',5),
(1024,'8dbb',3),
(1025,'8d0b',4),
(1026,'1a9f',10),
(1027,'535c',7),
(1027,'66c8',6),
(1027,'74dd',6),
(1028,'3a6a',1),
(1028,'4012',8),
(1028,'74dd',1),
(1029,'50b5',6),
(1030,'8905',10),
(1030,'90b0',9),
(1030,'7628',8),
(1031,'3e09',3),
(1031,'8d0b',7),
(1032,'74b8',6),
(1032,'9b60',8),
(1033,'4431',9),
(1033,'1963',9),
(1033,'6953',9),
(1034,'67e8',3),
(1035,'4b18',5),
(1035,'172f',5),
(1035,'251d',4),
(1035,'6b46',7),
(1036,'8905',6),
(1037,'5e70',3),
(1038,'8dbb',3),
(1039,'6d03',1),
(1039,'3690',5),
(1039,'8dbb',3),
(1039,'263e',7),
(1039,'4b18',6),
(1040,'16c9',1),
(1041,'93d8',2),
(1041,'4afc',8),
(1042,'3995',1),
(1043,'8a61',7),
(1044,'9701',5),
(1044,'263e',6),
(1045,'8b29',2),
(1045,'3690',2),
(1046,'1982',1),
(1047,'4323',5),
(1048,'3a70',3),
(1048,'93c8',10),
(1048,'601d',1),
(1049,'16f5',9),
(1049,'16c9',2),
(1049,'3690',6),
(1049,'25bd',6),
(1049,'9d8d',1),
(1050,'9b60',1),
(1050,'8bed',4),
(1050,'740f',10),
(1051,'1d70',3),
(1052,'9055',2),
(1052,'3995',10),
(1053,'4f27',2),
(1054,'31c8',8),
(1055,'94c5',1),
(1055,'1b6b',2),
(1056,'827e',6),
(1057,'71c2',6),
(1057,'733b',8),
(1057,'37ab',2),
(1058,'8b66',2),
(1058,'2bc0',6),
(1058,'5ce1',1),
(1058,'8605',5),
(1059,'4243',2),
(1060,'7edd',10),
(1061,'740f',6),
(1062,'90b0',5),
(1062,'1252',6),
(1063,'1d42',6),
(1063,'9695',2),
(1064,'9695',8),
(1064,'172f',3),
(1065,'200b',9),
(1066,'176f',2),
(1067,'7edd',2),
(1068,'8fd1',1),
(1068,'94e2',10),
(1068,'9695',4),
(1069,'1b6b',1),
(1070,'408f',5),
(1071,'4b18',2),
(1071,'1252',5),
(1072,'146a',10),
(1072,'140d',6),
(1072,'3128',4),
(1073,'140d',8),
(1074,'28d5',1),
(1074,'94e2',5),
(1074,'6e9b',8),
(1075,'17e1',8),
(1075,'17bf',10),
(1075,'3f4c',1),
(1075,'4b18',7),
(1075,'4fe4',3),
(1076,'237a',7),
(1077,'733b',5),
(1077,'16c9',8),
(1077,'32f7',5),
(1077,'9d8d',1),
(1077,'4afc',1),
(1078,'44a8',6),
(1078,'1a9f',1),
(1079,'8d0b',9),
(1080,'4431',3),
(1080,'8905',3),
(1080,'31c8',1),
(1081,'4796',2),
(1081,'949a',2),
(1082,'1a62',5),
(1083,'251d',7),
(1083,'408f',5),
(1083,'863c',5),
(1084,'3995',4),
(1085,'263e',3),
(1086,'17e1',5),
(1087,'86ec',2),
(1087,'81ab',4),
(1087,'8905',9),
(1087,'4925',1),
(1087,'7f5b',4),
(1088,'1df8',10),
(1088,'1b6b',1),
(1088,'4796',4),
(1088,'28d5',5),
(1089,'1252',9),
(1090,'3e09',4),
(1091,'81ab',10),
(1092,'4f27',10),
(1093,'1880',5),
(1093,'85ca',2),
(1093,'89c3',3),
(1094,'6b27',4),
(1094,'74b8',3),
(1094,'6b46',4),
(1095,'17e1',4),
(1095,'3995',8),
(1095,'140d',7),
(1095,'94e2',2),
(1096,'9695',2),
(1096,'4243',9),
(1096,'6d03',5),
(1097,'8bed',6),
(1097,'4b18',1),
(1097,'6d5d',1),
(1097,'71c2',1),
(1098,'4afc',3),
(1099,'94c5',9),
(1100,'8a43',10),
(1101,'1170',7),
(1102,'1982',2),
(1103,'535c',5),
(1103,'863c',7),
(1103,'6b27',1),
(1104,'7308',9),
(1105,'6601',5),
(1106,'6e9b',4),
(1107,'6b27',4),
(1107,'601d',7),
(1108,'25bd',8),
(1109,'94c5',8),
(1109,'1a62',7),
(1109,'6b27',9),
(1109,'6b46',9),
(1110,'31c8',3),
(1111,'1c15',5),
(1111,'6d5d',1),
(1111,'77c1',10),
(1111,'486a',9),
(1111,'740f',4),
(1112,'17bf',8),
(1113,'488d',2),
(1114,'146a',10),
(1115,'71c2',1),
(1116,'2406',7),
(1117,'8a61',6),
(1118,'1d70',4),
(1118,'74b8',8),
(1118,'535c',4),
(1119,'430f',4),
(1120,'5ce1',10),
(1120,'8b66',4),
(1120,'2249',2),
(1121,'2ed1',7),
(1122,'1c3d',6),
(1123,'4243',2),
(1123,'7308',4),
(1124,'2e2e',10),
(1125,'1a9f',4),
(1126,'6996',3),
(1126,'4afc',7),
(1126,'6953',8),
(1126,'71c2',1),
(1127,'98e7',2),
(1127,'4b18',3),
(1127,'8905',6),
(1128,'5a9d',4),
(1129,'173c',9),
(1130,'3128',5),
(1131,'1874',2),
(1131,'408f',3),
(1132,'5e70',6),
(1133,'16f5',6),
(1134,'93d8',5),
(1135,'488d',9),
(1135,'74b8',9),
(1135,'90b0',9),
(1136,'949a',3),
(1137,'1d42',2),
(1137,'67e8',6),
(1138,'173c',2),
(1139,'8b66',9),
(1139,'1982',6),
(1139,'488d',5),
(1140,'8526',7),
(1140,'80d8',6),
(1141,'595c',8),
(1141,'949a',10),
(1142,'2406',2),
(1142,'74dd',4),
(1143,'8dbb',6),
(1144,'200b',3),
(1145,'9695',8),
(1145,'6b27',6),
(1146,'3e09',1),
(1147,'8b29',2),
(1147,'4b18',6),
(1147,'4431',6),
(1147,'4f27',4),
(1148,'8b29',2),
(1149,'486a',5),
(1150,'9695',3),
(1150,'8a61',6),
(1150,'1c3d',7),
(1151,'1d70',3),
(1151,'98e7',10),
(1152,'4431',6),
(1153,'2499',3),
(1154,'3d5a',2),
(1154,'6e9b',4),
(1154,'486a',10),
(1154,'92c6',9),
(1154,'92c5',6),
(1154,'8526',3),
(1154,'1e5e',10),
(1154,'8a61',6),
(1154,'430f',4),
(1154,'93d8',8),
(1155,'77c1',9),
(1155,'9055',6),
(1155,'5ce1',2),
(1155,'1874',3),
(1156,'263e',9),
(1156,'8bed',1),
(1156,'176f',4),
(1157,'8905',6),
(1157,'237a',3),
(1158,'172f',6),
(1159,'8146',5),
(1159,'4431',7),
(1160,'7308',5),
(1160,'1170',7),
(1161,'3b82',2),
(1161,'8b66',6),
(1161,'1a9f',8),
(1162,'89c3',6),
(1163,'1880',3),
(1164,'74b8',8),
(1164,'98e7',9),
(1164,'1a9f',4),
(1164,'755b',8),
(1165,'66c8',2),
(1165,'200b',5),
(1165,'1e5e',4),
(1165,'4873',5),
(1165,'8b29',2),
(1165,'8526',9),
(1166,'25bd',2),
(1166,'4796',6),
(1166,'6b46',4),
(1167,'44a8',7),
(1168,'66c8',9),
(1168,'601d',6),
(1168,'9bff',8),
(1168,'3b82',3),
(1168,'51b5',4),
(1168,'9055',2),
(1168,'2249',10),
(1169,'4ace',9),
(1170,'67e8',8),
(1170,'863c',3),
(1170,'1d70',10),
(1171,'9695',6),
(1172,'93d8',3),
(1172,'7713',5),
(1172,'77c1',10),
(1172,'5a9d',3),
(1173,'4012',5),
(1174,'9b60',5),
(1174,'16c9',6),
(1174,'184e',7),
(1175,'86ec',5),
(1176,'28d5',2),
(1177,'4012',1),
(1177,'1a62',4),
(1177,'3111',9),
(1178,'4873',8),
(1179,'2499',4),
(1179,'8a61',3),
(1180,'1a62',1),
(1181,'7713',8),
(1181,'408f',8),
(1182,'6d94',6),
(1183,'5ce1',3),
(1183,'5e70',5),
(1183,'81ab',9),
(1184,'9d4a',7),
(1184,'3a70',9),
(1185,'9701',1),
(1186,'31c8',8),
(1187,'8d0b',2),
(1187,'8a43',4),
(1187,'1963',7),
(1188,'7713',6),
(1189,'94c5',5),
(1190,'17bf',3),
(1190,'5e70',8),
(1190,'31c8',5),
(1191,'535c',4),
(1192,'9055',10),
(1192,'3d5a',3),
(1193,'4cc9',9),
(1194,'98e7',6),
(1194,'2bc0',7),
(1195,'9701',2),
(1196,'535c',2),
(1196,'4873',6),
(1196,'2ed1',8),
(1196,'9695',1),
(1197,'9b60',1),
(1197,'4323',3),
(1198,'74dd',7),
(1199,'8b66',4),
(1199,'9d8d',5),
(1199,'4fe4',2),
(1199,'1aac',9),
(1199,'8fd1',3),
(1199,'98e7',6),
(1200,'4012',2),
(1200,'71c2',5),
(1201,'17e1',7),
(1202,'3128',1),
(1203,'1ade',8),
(1204,'263e',3),
(1205,'595c',5),
(1206,'90b0',3),
(1207,'755b',8),
(1207,'50b5',10),
(1207,'8b66',1),
(1207,'488d',1),
(1208,'8146',1),
(1208,'1982',5),
(1209,'6d94',7),
(1209,'4ace',6),
(1210,'4afc',3),
(1211,'3a6a',1),
(1212,'559f',4),
(1212,'1d70',4),
(1212,'1c3d',3),
(1213,'5a9d',7),
(1213,'9055',1),
(1214,'1982',9),
(1214,'94e2',10),
(1215,'28d5',1),
(1216,'2249',6),
(1216,'4cc9',7),
(1217,'90b0',10),
(1217,'3b82',4),
(1218,'8b66',6),
(1218,'601d',6),
(1219,'3e09',4),
(1220,'9253',1),
(1221,'595c',9),
(1222,'1963',9),
(1223,'1b6b',10),
(1223,'4ace',8),
(1223,'200b',1),
(1224,'50b5',2),
(1225,'3b82',7),
(1225,'4796',2),
(1225,'4243',1),
(1226,'7f5b',4),
(1227,'6953',10),
(1228,'488d',5),
(1229,'184e',10),
(1230,'1432',1),
(1231,'7ecd',6),
(1231,'6996',8),
(1232,'31c8',3),
(1233,'6b46',9),
(1233,'595c',3),
(1233,'4243',2),
(1233,'93c8',9),
(1233,'7713',7),
(1234,'3e09',10),
(1234,'4cc9',5),
(1235,'6d94',9),
(1235,'98e7',3),
(1235,'9701',4),
(1235,'7ecd',6),
(1236,'4873',1),
(1237,'92c6',7),
(1237,'1c3d',9),
(1237,'4b18',4),
(1237,'7713',6),
(1237,'25bd',8),
(1237,'4796',2),
(1238,'8460',6),
(1238,'66c8',7),
(1239,'5ce1',8),
(1239,'2e2e',5),
(1240,'184e',8),
(1241,'1a62',9),
(1242,'6b46',7),
(1243,'28d5',4),
(1244,'9b60',5),
(1244,'5744',2),
(1244,'687b',3),
(1245,'184e',8),
(1245,'6e9b',7),
(1245,'827e',10),
(1245,'98e7',9),
(1246,'4b18',7),
(1247,'8d0b',4),
(1247,'8a61',2),
(1248,'1963',2),
(1248,'6d5d',6),
(1248,'28d5',2),
(1249,'172f',5),
(1249,'4796',3),
(1250,'1ade',2),
(1250,'3128',8),
(1250,'1c15',1),
(1251,'4012',5),
(1251,'2bc0',2),
(1252,'85d3',3),
(1253,'733b',10),
(1253,'1a62',8),
(1253,'2406',3),
(1254,'5ce1',1),
(1255,'740f',5),
(1256,'2e2e',9),
(1257,'6996',3),
(1258,'188e',4),
(1258,'8460',10),
(1259,'237a',7),
(1260,'35af',7),
(1260,'3995',7),
(1260,'44a8',7),
(1261,'80d8',1),
(1262,'3995',10),
(1263,'2249',5),
(1263,'8460',9),
(1264,'90b0',4),
(1265,'1c3d',5),
(1265,'551f',9),
(1266,'4431',3),
(1267,'35af',4),
(1267,'74b8',5),
(1268,'3a70',10),
(1269,'8460',8),
(1270,'9055',9),
(1271,'6d03',9),
(1272,'733b',3),
(1273,'8526',2),
(1274,'1d42',5),
(1274,'780d',8),
(1275,'1982',1),
(1276,'16c9',7),
(1276,'35af',1),
(1277,'25bd',10),
(1278,'1c3d',5),
(1279,'687b',8),
(1280,'4f27',7),
(1280,'2406',1),
(1280,'1963',9),
(1280,'80d8',5),
(1281,'8460',4),
(1282,'4afc',6),
(1282,'2499',10),
(1283,'4431',2),
(1284,'31c8',10),
(1285,'1e5e',4),
(1286,'16f5',9),
(1287,'3d5a',4),
(1287,'172f',4),
(1287,'16f5',1),
(1288,'6953',1),
(1288,'1880',5),
(1289,'44a8',7),
(1289,'6b46',4),
(1289,'92c6',3),
(1289,'74b8',4),
(1290,'5e70',9),
(1291,'37ab',4),
(1291,'92c5',8),
(1292,'2a73',9),
(1292,'2499',4),
(1292,'1a62',8),
(1292,'8a61',8),
(1292,'200b',10),
(1292,'35af',1),
(1292,'4fe4',8),
(1293,'687b',10),
(1293,'85d3',5),
(1294,'37ab',1),
(1294,'3f4c',7),
(1295,'8dbb',7),
(1296,'8526',9),
(1297,'51b5',8),
(1298,'755b',3),
(1298,'9055',4),
(1298,'31c8',1),
(1299,'1ade',1),
(1299,'263e',10),
(1300,'80d8',8),
(1301,'8460',1),
(1301,'2249',3),
(1302,'9d8d',2),
(1302,'6e9b',9),
(1303,'7ecd',6),
(1303,'173c',7),
(1304,'8460',5),
(1305,'89c3',9),
(1306,'27c3',6),
(1306,'4925',3),
(1307,'1c15',6),
(1308,'430f',9),
(1309,'17e1',4),
(1310,'4cc9',1),
(1310,'80d8',10),
(1310,'28d5',9),
(1310,'2ed1',7),
(1311,'7713',6),
(1311,'173c',5),
(1312,'4796',6),
(1313,'8605',2),
(1314,'2e2e',6),
(1314,'71c2',9),
(1314,'8460',1),
(1315,'551f',6),
(1316,'71c2',8),
(1317,'6d03',8),
(1318,'5744',1),
(1319,'2ed1',10),
(1320,'8fd1',8),
(1321,'486a',7),
(1321,'78fb',8),
(1321,'1982',2),
(1321,'237a',6),
(1322,'3995',10),
(1323,'2249',7),
(1323,'90b0',8),
(1324,'3995',3),
(1324,'559f',10),
(1325,'3e09',9),
(1326,'430f',4),
(1327,'89c3',3),
(1328,'9b60',10),
(1328,'486a',4),
(1328,'6b27',2),
(1328,'81ab',7),
(1329,'4796',10),
(1330,'86ec',6),
(1331,'44a8',7),
(1332,'89c3',7),
(1333,'3995',6),
(1333,'4796',2),
(1333,'5a9d',7),
(1333,'6e9b',2),
(1334,'2ed1',9),
(1335,'7ecd',3),
(1335,'7628',8),
(1335,'9b60',8),
(1336,'2bc0',7),
(1336,'488d',5),
(1337,'8bed',4),
(1337,'50b5',5),
(1337,'6953',5),
(1337,'58a5',3),
(1337,'51b5',6),
(1337,'6d03',10),
(1338,'949a',8),
(1338,'6e9b',7),
(1338,'16c9',1),
(1338,'37ab',1),
(1339,'1432',2),
(1339,'4012',1),
(1340,'4243',9),
(1341,'4cc9',6),
(1342,'6c70',5),
(1343,'687b',6),
(1343,'7ecd',8),
(1344,'94c5',10),
(1344,'6d5d',9),
(1345,'81ab',6),
(1345,'1b6b',9),
(1346,'9bff',10),
(1347,'6d5d',3),
(1347,'173c',4),
(1347,'3111',6),
(1347,'8bed',2),
(1347,'8146',4),
(1347,'1432',5),
(1347,'176f',6),
(1348,'9bff',9),
(1349,'8dbb',8),
(1349,'92c6',3),
(1349,'3f4c',7),
(1349,'755b',7),
(1350,'2ed1',8),
(1350,'5ce1',9),
(1351,'8d0b',3),
(1351,'1a9f',7),
(1351,'251d',7),
(1352,'35af',3),
(1352,'146a',3),
(1352,'863c',10),
(1353,'94e2',3),
(1354,'6c70',7),
(1354,'8a43',6),
(1354,'146a',6),
(1355,'90b0',1),
(1355,'58a5',4),
(1356,'200b',4),
(1356,'4012',10),
(1357,'755b',10),
(1358,'2a73',9),
(1359,'6b46',6),
(1360,'35af',10),
(1361,'140d',1),
(1362,'7628',10),
(1363,'2a73',9),
(1363,'90b0',4),
(1363,'8b66',10),
(1363,'1c15',8),
(1364,'237a',10),
(1365,'4431',5),
(1365,'35af',6),
(1365,'4afc',2),
(1366,'9055',5),
(1367,'58a5',6),
(1367,'32f7',1),
(1367,'1a62',6),
(1368,'74dd',9),
(1368,'176f',3),
(1368,'1982',9),
(1369,'488d',8),
(1369,'93d8',3),
(1370,'85ca',1),
(1370,'92c5',5),
(1371,'4cc9',10),
(1372,'8fd1',10),
(1373,'4243',3),
(1374,'559f',8),
(1374,'16f5',8),
(1375,'1982',3),
(1375,'3e09',3),
(1376,'3a6a',7),
(1377,'1880',4),
(1378,'4873',1),
(1378,'1874',6),
(1379,'93c8',5),
(1380,'780d',6),
(1380,'949a',4),
(1380,'7713',10),
(1380,'51b5',7),
(1381,'2e2e',10),
(1381,'172f',10),
(1382,'78fb',3),
(1382,'81ab',1),
(1383,'3128',5),
(1384,'6d94',7),
(1385,'4925',2),
(1385,'2249',10),
(1385,'1874',10),
(1386,'58a5',8),
(1387,'8b29',2),
(1388,'89c3',3),
(1389,'1e5e',4),
(1390,'98e7',1),
(1391,'74dd',1),
(1391,'3f4c',7),
(1391,'93c8',1),
(1392,'32f7',10),
(1393,'184e',10),
(1394,'4b18',4),
(1395,'85d3',10),
(1395,'486a',9),
(1395,'32f7',3),
(1396,'3995',5),
(1396,'67e8',1),
(1397,'1170',2),
(1398,'408f',7),
(1398,'4323',1),
(1398,'949a',3),
(1398,'9701',3),
(1399,'3995',6),
(1399,'200b',10),
(1400,'51b5',9),
(1401,'4796',10),
(1402,'94c5',4),
(1402,'92c5',3),
(1403,'755b',9),
(1404,'7f5b',4),
(1405,'2e2e',10),
(1405,'140d',10),
(1406,'28d5',7),
(1406,'37ab',10),
(1407,'3d5a',5),
(1408,'74dd',1),
(1408,'6c70',4),
(1408,'3a6a',3),
(1408,'6d5d',7),
(1409,'5a9d',4),
(1410,'9695',9),
(1410,'1963',4),
(1410,'37ab',8),
(1410,'4071',9),
(1411,'172f',7),
(1412,'1aac',7),
(1412,'4fe4',10),
(1413,'740f',6),
(1414,'51b5',9),
(1414,'5ce1',7),
(1414,'6c70',4),
(1414,'8d0b',6),
(1415,'140d',2),
(1416,'8a43',2),
(1417,'8bed',7),
(1417,'92c5',1),
(1417,'3995',10),
(1418,'89c3',9),
(1419,'595c',8),
(1420,'85ca',10),
(1420,'8605',7),
(1420,'6c70',5),
(1420,'176f',6),
(1420,'263e',6),
(1420,'32f7',10),
(1420,'237a',4),
(1420,'37ab',4),
(1420,'733b',8),
(1421,'77c1',6),
(1421,'740f',8),
(1421,'4071',8),
(1422,'1d42',9),
(1422,'71c2',10),
(1423,'687b',8),
(1424,'488d',3),
(1424,'4925',8),
(1425,'74b8',4),
(1425,'1874',6),
(1426,'827e',9),
(1426,'50b5',6),
(1426,'2406',7),
(1427,'780d',5),
(1428,'98e7',1),
(1429,'4323',1),
(1429,'93c8',8),
(1430,'6996',7),
(1430,'4873',4),
(1430,'1a9f',10),
(1430,'176f',1),
(1430,'8d0b',3),
(1431,'89c3',9),
(1432,'1880',3),
(1433,'780d',3),
(1433,'93c8',10),
(1433,'687b',9),
(1434,'1880',5),
(1435,'86ec',7),
(1436,'263e',7),
(1437,'535c',8),
(1437,'31c8',10),
(1438,'4323',8),
(1438,'2249',1),
(1439,'188e',6),
(1439,'89c3',10),
(1440,'2e2e',2),
(1440,'535c',10),
(1441,'1d70',5),
(1442,'93c8',7),
(1443,'8a43',9),
(1444,'551f',1),
(1444,'4431',6),
(1444,'93d8',8),
(1445,'4243',9),
(1445,'1e5e',9),
(1446,'3b82',7),
(1446,'263e',3),
(1446,'9d8d',3),
(1447,'3a70',4),
(1448,'551f',7),
(1449,'9055',4),
(1450,'94e2',2),
(1451,'3128',6),
(1451,'9b60',2),
(1452,'8d0b',9),
(1452,'1982',5),
(1453,'32f7',7),
(1454,'2ed1',2),
(1454,'94c5',9),
(1455,'9055',3),
(1455,'2bc0',3),
(1455,'551f',6),
(1456,'9bff',7),
(1457,'188e',4),
(1458,'32f7',2),
(1459,'44a8',10),
(1459,'4071',7),
(1459,'31c8',9),
(1459,'251d',1),
(1460,'4796',6),
(1461,'184e',5),
(1462,'51b5',5),
(1463,'2499',4),
(1463,'408f',5),
(1463,'50b5',7),
(1464,'2249',5),
(1465,'949a',10),
(1466,'3995',3),
(1466,'44a8',3),
(1467,'8dbb',3),
(1467,'71c2',8),
(1468,'86ec',1),
(1468,'17e1',8),
(1469,'9bff',6),
(1469,'1a62',5),
(1470,'3d5a',7),
(1470,'2406',8),
(1471,'1432',10),
(1472,'430f',5),
(1472,'827e',8),
(1473,'200b',1),
(1473,'5e70',7),
(1473,'251d',4),
(1474,'3d5a',5),
(1475,'80d8',4),
(1476,'74b8',10),
(1476,'949a',7),
(1476,'237a',2),
(1476,'1c15',8),
(1476,'1ade',10),
(1476,'8526',4),
(1477,'3995',2),
(1478,'3128',2),
(1479,'2249',2),
(1479,'176f',8),
(1479,'8605',5),
(1480,'80d8',6),
(1481,'8b66',5),
(1481,'535c',8),
(1482,'551f',6),
(1482,'44a8',10),
(1482,'3a6a',10),
(1482,'28d5',5),
(1482,'9701',3),
(1483,'3f89',10),
(1483,'263e',5),
(1483,'92c5',6),
(1484,'8d0b',7),
(1485,'80d8',2),
(1485,'6d94',4),
(1486,'949a',3),
(1487,'4243',5),
(1487,'2249',3),
(1488,'44a8',10),
(1488,'9701',1),
(1488,'1df8',1),
(1488,'1874',6),
(1488,'4431',9),
(1489,'28d5',7),
(1490,'17bf',1),
(1491,'2bc0',3),
(1491,'6c70',3),
(1491,'8905',3),
(1492,'7ecd',4),
(1492,'1a62',4),
(1492,'3690',6),
(1492,'1432',3),
(1492,'3f89',5),
(1492,'85d3',9),
(1493,'4431',8),
(1493,'251d',6),
(1494,'7f5b',5),
(1494,'430f',3),
(1494,'3f89',9),
(1495,'6953',1),
(1495,'9d8d',1),
(1496,'51b5',4),
(1496,'50b5',4),
(1496,'176f',7),
(1497,'3690',1),
(1497,'17e1',2),
(1497,'50b5',4),
(1497,'92c5',8),
(1497,'1c3d',2),
(1498,'8fd1',10),
(1499,'6d5d',4),
(1500,'9d4a',4),
(1500,'3f4c',3),
(1501,'1e5e',8),
(1501,'16c9',2),
(1502,'3128',1),
(1503,'755b',6),
(1503,'44a8',1),
(1504,'1d42',4),
(1505,'6e9b',10),
(1505,'486a',5),
(1506,'6d5d',10),
(1507,'31c8',2),
(1507,'44a8',3),
(1508,'80d8',3),
(1509,'94c5',2),
(1510,'85ca',8),
(1510,'8fd1',10),
(1510,'4323',6),
(1510,'67e8',8),
(1510,'8b29',4),
(1511,'3111',6),
(1511,'81ab',8),
(1512,'8d0b',7),
(1513,'92c6',9),
(1513,'8dbb',9),
(1514,'6d5d',10),
(1514,'3128',4),
(1514,'9253',10),
(1515,'4873',2),
(1515,'77c1',2),
(1515,'8460',5),
(1516,'9d4a',7),
(1517,'16f5',6),
(1517,'200b',6),
(1518,'551f',7),
(1518,'3a6a',4),
(1518,'8fd1',3),
(1519,'98e7',5),
(1519,'5744',3),
(1519,'4243',7),
(1520,'140d',1),
(1521,'9055',4),
(1522,'827e',4),
(1523,'3128',6),
(1524,'93d8',3),
(1524,'9bff',1),
(1524,'74b8',2),
(1525,'8146',10),
(1526,'3f4c',9),
(1527,'16f5',10),
(1528,'8bed',7),
(1529,'81ab',2),
(1529,'25bd',8),
(1529,'8a43',3),
(1530,'1e5e',8),
(1530,'4873',6),
(1531,'1a62',6),
(1532,'687b',10),
(1532,'16f5',9),
(1532,'7f5b',2),
(1533,'140d',3),
(1534,'1432',8),
(1535,'140d',3),
(1535,'1982',6),
(1535,'17e1',7),
(1535,'94e2',6),
(1535,'80d8',9),
(1536,'4ace',1),
(1537,'6c70',9),
(1537,'3d5a',4),
(1537,'4ace',8),
(1538,'27c3',4),
(1538,'2ed1',8),
(1538,'8526',5),
(1539,'7edd',5),
(1539,'1df8',6),
(1539,'1982',6),
(1539,'1e5e',8),
(1539,'140d',3),
(1539,'601d',1),
(1540,'81ab',8),
(1541,'6d94',2),
(1541,'2e2e',2),
(1541,'3f4c',10),
(1541,'1874',6),
(1541,'1880',3),
(1541,'140d',3),
(1542,'1aac',8),
(1543,'863c',1),
(1544,'81ab',2),
(1545,'184e',6),
(1545,'7308',4),
(1545,'2249',2),
(1545,'595c',6),
(1546,'3995',4),
(1546,'827e',1),
(1546,'17bf',9),
(1546,'8dbb',1),
(1546,'1874',5),
(1546,'1df8',3),
(1547,'3f4c',5),
(1547,'1aac',10),
(1547,'6601',2),
(1547,'2a73',3),
(1548,'2a73',7),
(1548,'1c15',4),
(1549,'2e2e',4),
(1549,'176f',3),
(1549,'4b18',6),
(1549,'3128',8);

SELECT COUNT(*) AS TOTAL FROM ORDER_PRODUCT_MAPPING;

SELECT *  FROM ORDER_PRODUCT_MAPPING;
#_____________________________________________________________________________________
-- Loading data into SALES_FACT-- INSERTING RECORDS INTO SALES_FACT

INSERT INTO SALES_FACT VALUES
(1000,161,'2020-04-05',5),
(1001,137,'2020-01-06',5),
(1002,169,'2020-12-17',6),
(1003,183,'2020-04-16',4),
(1004,108,'2020-06-30',6),
(1005,127,'2020-08-24',10),
(1006,190,'2020-04-01',3),
(1007,156,'2021-02-16',7),
(1008,175,'2020-12-09',9),
(1009,198,'2021-01-20',4),
(1010,140,'2020-07-19',6),
(1011,173,'2020-09-25',8),
(1012,158,'2020-09-16',9),
(1013,147,'2020-07-14',1),
(1014,182,'2021-01-05',1),
(1015,185,'2021-02-26',4),
(1016,135,'2020-12-20',3),
(1017,158,'2021-01-08',9),
(1018,125,'2020-12-04',8),
(1019,172,'2021-02-05',6),
(1020,194,'2020-08-25',6),
(1021,139,'2021-03-02',6),
(1022,197,'2020-01-29',9),
(1023,113,'2020-10-28',3),
(1024,134,'2021-02-20',3),
(1025,150,'2020-02-17',3),
(1026,144,'2020-07-15',6),
(1027,105,'2020-07-12',8),
(1028,188,'2020-05-12',1),
(1029,195,'2021-03-02',3),
(1030,105,'2020-10-24',10),
(1031,181,'2020-02-19',5),
(1032,178,'2020-12-31',2),
(1033,105,'2020-03-15',2),
(1034,160,'2020-05-21',6),
(1035,109,'2020-07-06',10),
(1036,145,'2020-06-22',6),
(1037,143,'2021-01-21',2),
(1038,186,'2020-06-22',6),
(1039,151,'2020-02-24',4),
(1040,155,'2020-01-14',1),
(1041,111,'2020-07-28',6),
(1042,179,'2020-01-06',4),
(1043,120,'2021-02-23',2),
(1044,126,'2020-09-23',7),
(1045,128,'2020-08-15',9),
(1046,105,'2020-06-27',10),
(1047,167,'2021-03-18',10),
(1048,120,'2020-04-27',8),
(1049,174,'2021-01-10',2),
(1050,125,'2020-08-18',8),
(1051,137,'2021-02-08',8),
(1052,106,'2020-03-14',4),
(1053,182,'2020-02-07',5),
(1054,196,'2020-04-29',2),
(1055,154,'2021-01-05',1),
(1056,163,'2020-08-31',2),
(1057,123,'2020-12-23',8),
(1058,198,'2020-08-07',9),
(1059,189,'2020-05-28',1),
(1060,120,'2020-01-05',2),
(1061,179,'2020-06-15',8),
(1062,139,'2021-01-29',5),
(1063,197,'2020-07-13',4),
(1064,118,'2021-02-11',2),
(1065,158,'2020-05-22',9),
(1066,182,'2020-06-20',7),
(1067,180,'2020-06-28',9),
(1068,200,'2021-03-24',1),
(1069,116,'2020-12-16',2),
(1070,117,'2020-07-18',8),
(1071,134,'2020-01-28',10),
(1072,125,'2020-10-15',8),
(1073,121,'2020-08-26',5),
(1074,104,'2020-08-31',8),
(1075,178,'2020-06-03',2),
(1076,195,'2020-03-14',6),
(1077,166,'2020-02-11',8),
(1078,165,'2021-01-03',4),
(1079,177,'2020-03-11',3),
(1080,106,'2021-03-04',10),
(1081,140,'2020-11-10',3),
(1082,120,'2020-07-08',1),
(1083,145,'2021-01-28',3),
(1084,134,'2021-02-20',4),
(1085,182,'2021-01-21',8),
(1086,154,'2020-09-16',8),
(1087,105,'2021-03-08',3),
(1088,102,'2020-11-20',2),
(1089,145,'2020-04-08',1),
(1090,137,'2021-02-08',6),
(1091,133,'2020-11-13',2),
(1092,152,'2020-02-26',8),
(1093,185,'2020-03-03',1),
(1094,135,'2020-02-20',3),
(1095,153,'2021-02-23',3),
(1096,185,'2020-02-26',5),
(1097,150,'2020-05-24',8),
(1098,187,'2021-04-01',10),
(1099,102,'2020-08-11',2),
(1100,176,'2020-07-17',2),
(1101,172,'2020-11-13',2),
(1102,174,'2020-01-25',9),
(1103,126,'2020-05-31',7),
(1104,152,'2020-12-16',8),
(1105,146,'2020-05-08',5),
(1106,184,'2020-04-14',4),
(1107,122,'2020-12-09',8),
(1108,133,'2020-02-24',2),
(1109,104,'2020-07-09',4),
(1110,121,'2020-07-18',6),
(1111,155,'2020-07-01',8),
(1112,131,'2021-01-24',6),
(1113,162,'2020-12-26',1),
(1114,177,'2020-08-31',8),
(1115,177,'2020-09-06',9),
(1116,166,'2020-04-23',6),
(1117,197,'2020-09-13',7),
(1118,151,'2020-12-04',7),
(1119,132,'2020-02-29',4),
(1120,191,'2021-02-08',1),
(1121,196,'2020-08-21',10),
(1122,175,'2020-03-08',6),
(1123,198,'2020-07-14',1),
(1124,100,'2020-10-31',5),
(1125,187,'2020-04-18',6),
(1126,151,'2020-10-07',2),
(1127,180,'2021-03-02',4),
(1128,104,'2020-02-19',7),
(1129,114,'2020-02-15',6),
(1130,167,'2020-08-28',4),
(1131,194,'2020-09-30',3),
(1132,150,'2021-01-26',5),
(1133,133,'2020-04-17',6),
(1134,113,'2020-06-25',4),
(1135,120,'2020-04-05',7),
(1136,126,'2020-12-04',1),
(1137,161,'2020-11-25',2),
(1138,178,'2021-02-08',5),
(1139,110,'2020-06-20',6),
(1140,176,'2020-01-21',9),
(1141,105,'2021-02-17',5),
(1142,156,'2021-02-25',6),
(1143,152,'2021-03-16',9),
(1144,190,'2020-07-24',10),
(1145,170,'2020-09-27',10),
(1146,109,'2020-07-10',3),
(1147,168,'2020-08-01',8),
(1148,136,'2020-10-17',2),
(1149,184,'2020-09-02',10),
(1150,194,'2020-08-10',5),
(1151,188,'2020-03-04',6),
(1152,169,'2021-02-11',7),
(1153,163,'2020-12-09',4),
(1154,129,'2020-06-12',7),
(1155,142,'2020-08-04',3),
(1156,184,'2021-01-20',7),
(1157,181,'2020-06-01',9),
(1158,199,'2020-06-13',3),
(1159,104,'2020-10-31',4),
(1160,104,'2020-03-15',5),
(1161,133,'2020-09-23',6),
(1162,147,'2020-11-14',7),
(1163,132,'2020-06-14',3),
(1164,138,'2020-01-27',1),
(1165,129,'2021-03-09',4),
(1166,188,'2020-05-02',4),
(1167,177,'2020-08-11',7),
(1168,124,'2020-08-01',4),
(1169,154,'2020-09-30',2),
(1170,123,'2020-03-21',4),
(1171,181,'2020-09-29',4),
(1172,131,'2020-10-23',3),
(1173,195,'2020-06-21',6),
(1174,117,'2020-05-06',10),
(1175,133,'2020-04-12',10),
(1176,153,'2020-04-19',7),
(1177,101,'2021-02-05',7),
(1178,118,'2020-09-30',4),
(1179,119,'2020-07-11',3),
(1180,136,'2020-09-23',10),
(1181,130,'2020-02-12',3),
(1182,170,'2020-08-11',10),
(1183,163,'2020-09-20',2),
(1184,165,'2020-06-09',2),
(1185,113,'2020-09-22',10),
(1186,167,'2020-04-17',8),
(1187,194,'2021-03-27',9),
(1188,116,'2020-05-28',1),
(1189,168,'2020-11-15',2),
(1190,166,'2020-07-30',9),
(1191,104,'2020-07-31',3),
(1192,193,'2020-04-23',5),
(1193,113,'2020-08-29',4),
(1194,198,'2020-09-04',9),
(1195,184,'2020-07-16',5),
(1196,167,'2021-03-14',3),
(1197,172,'2020-06-19',5),
(1198,110,'2020-09-01',8),
(1199,131,'2020-02-27',6),
(1200,106,'2020-07-24',5),
(1201,107,'2021-01-03',5),
(1202,104,'2020-11-15',5),
(1203,153,'2020-12-12',7),
(1204,178,'2021-02-02',4),
(1205,200,'2020-07-28',10),
(1206,147,'2020-08-14',10),
(1207,145,'2020-01-19',1),
(1208,157,'2020-05-24',6),
(1209,134,'2020-04-05',2),
(1210,100,'2020-06-10',7),
(1211,160,'2020-05-16',10),
(1212,150,'2021-03-31',3),
(1213,183,'2020-11-07',2),
(1214,163,'2020-03-28',4),
(1215,116,'2021-01-20',10),
(1216,138,'2020-03-02',9),
(1217,118,'2020-09-20',9),
(1218,130,'2020-06-27',5),
(1219,167,'2020-10-10',10),
(1220,131,'2020-07-05',4),
(1221,164,'2020-10-16',6),
(1222,185,'2020-03-12',4),
(1223,108,'2020-11-19',9),
(1224,192,'2020-10-31',8),
(1225,197,'2020-11-18',7),
(1226,146,'2020-05-30',2),
(1227,149,'2020-07-18',8),
(1228,103,'2020-03-03',3),
(1229,197,'2020-07-15',10),
(1230,163,'2020-06-10',5),
(1231,105,'2020-01-29',5),
(1232,186,'2020-07-07',3),
(1233,103,'2020-10-06',3),
(1234,102,'2020-04-12',10),
(1235,130,'2021-01-29',9),
(1236,162,'2020-02-13',3),
(1237,199,'2020-08-19',1),
(1238,174,'2021-03-15',2),
(1239,169,'2020-12-29',5),
(1240,107,'2020-11-10',8),
(1241,117,'2020-12-16',7),
(1242,198,'2020-12-24',9),
(1243,142,'2020-05-08',10),
(1244,132,'2021-03-06',2),
(1245,104,'2020-06-26',2),
(1246,144,'2020-04-15',10),
(1247,129,'2020-09-08',8),
(1248,161,'2020-09-30',1),
(1249,103,'2021-03-20',8),
(1250,131,'2020-02-08',4),
(1251,105,'2020-06-28',10),
(1252,147,'2021-03-22',10),
(1253,104,'2020-06-21',8),
(1254,198,'2020-02-22',5),
(1255,111,'2020-05-18',2),
(1256,162,'2020-11-25',4),
(1257,120,'2020-01-29',10),
(1258,134,'2020-12-29',6),
(1259,120,'2020-10-14',10),
(1260,133,'2020-09-22',9),
(1261,155,'2020-11-25',5),
(1262,106,'2020-08-03',4),
(1263,180,'2020-10-24',4),
(1264,124,'2020-03-30',5),
(1265,101,'2021-03-30',2),
(1266,113,'2020-03-01',10),
(1267,175,'2020-05-14',9),
(1268,190,'2020-10-14',7),
(1269,133,'2021-02-13',3),
(1270,199,'2021-02-19',8),
(1271,153,'2020-05-08',4),
(1272,158,'2020-08-23',1),
(1273,148,'2021-02-04',1),
(1274,101,'2020-06-02',2),
(1275,117,'2020-05-08',9),
(1276,175,'2020-12-14',4),
(1277,122,'2020-11-27',3),
(1278,199,'2021-01-24',9),
(1279,174,'2020-09-02',10),
(1280,121,'2020-04-22',8),
(1281,196,'2020-03-07',7),
(1282,175,'2020-04-08',2),
(1283,197,'2020-04-30',8),
(1284,169,'2020-05-11',7),
(1285,122,'2020-01-26',6),
(1286,152,'2021-02-14',7),
(1287,143,'2020-04-17',9),
(1288,139,'2020-11-03',6),
(1289,131,'2021-02-16',6),
(1290,136,'2021-03-17',2),
(1291,185,'2021-02-23',9),
(1292,168,'2020-10-15',6),
(1293,198,'2020-07-25',7),
(1294,126,'2021-02-15',7),
(1295,156,'2020-11-14',4),
(1296,162,'2020-12-22',4),
(1297,134,'2020-01-17',8),
(1298,117,'2020-03-29',7),
(1299,117,'2021-02-06',4),
(1300,178,'2020-05-25',10),
(1301,149,'2020-06-19',3),
(1302,140,'2021-01-24',2),
(1303,192,'2020-08-17',10),
(1304,100,'2021-02-06',8),
(1305,105,'2021-02-13',4),
(1306,109,'2020-06-11',5),
(1307,176,'2020-04-09',5),
(1308,197,'2020-05-26',7),
(1309,150,'2020-12-28',5),
(1310,132,'2020-10-15',3),
(1311,167,'2020-10-05',6),
(1312,116,'2020-04-23',9),
(1313,151,'2020-08-21',1),
(1314,150,'2020-10-14',10),
(1315,122,'2020-11-10',10),
(1316,163,'2020-03-30',7),
(1317,191,'2020-03-24',1),
(1318,129,'2020-09-08',4),
(1319,167,'2020-08-29',6),
(1320,102,'2021-01-01',4),
(1321,137,'2020-09-30',1),
(1322,104,'2020-04-06',6),
(1323,161,'2020-12-22',6),
(1324,122,'2020-07-02',3),
(1325,131,'2020-09-17',10),
(1326,115,'2020-04-04',7),
(1327,174,'2020-01-27',9),
(1328,158,'2021-01-28',6),
(1329,143,'2020-02-20',5),
(1330,170,'2020-10-08',7),
(1331,185,'2020-02-11',7),
(1332,160,'2020-06-20',6),
(1333,151,'2020-01-17',2),
(1334,185,'2021-03-01',6),
(1335,200,'2020-03-17',2),
(1336,157,'2020-11-12',7),
(1337,164,'2020-07-24',8),
(1338,193,'2020-12-18',10),
(1339,164,'2020-08-16',5),
(1340,176,'2020-06-04',2),
(1341,115,'2020-01-11',6),
(1342,198,'2021-03-28',3),
(1343,179,'2020-04-02',6),
(1344,150,'2020-11-05',4),
(1345,170,'2021-03-30',7),
(1346,144,'2021-02-13',6),
(1347,167,'2020-12-17',2),
(1348,120,'2020-01-31',1),
(1349,183,'2020-03-01',3),
(1350,136,'2020-10-14',6),
(1351,107,'2021-03-11',6),
(1352,153,'2020-12-24',5),
(1353,193,'2020-05-05',2),
(1354,191,'2020-09-28',8),
(1355,185,'2020-08-30',7),
(1356,155,'2021-02-10',5),
(1357,175,'2020-06-18',1),
(1358,156,'2020-01-19',6),
(1359,194,'2020-09-29',2),
(1360,172,'2020-03-14',8),
(1361,160,'2020-10-27',9),
(1362,109,'2020-05-29',7),
(1363,125,'2020-06-03',9),
(1364,133,'2021-01-15',2),
(1365,173,'2020-11-12',10),
(1366,138,'2020-06-17',4),
(1367,123,'2020-10-22',9),
(1368,189,'2021-03-27',10),
(1369,109,'2020-05-03',1),
(1370,143,'2020-02-20',5),
(1371,165,'2020-02-14',3),
(1372,136,'2020-11-21',4),
(1373,162,'2020-09-10',2),
(1374,137,'2021-01-10',7),
(1375,140,'2021-02-12',6),
(1376,157,'2020-10-07',4),
(1377,171,'2020-11-18',2),
(1378,165,'2021-02-23',8),
(1379,122,'2021-02-14',10),
(1380,177,'2021-03-28',9),
(1381,181,'2020-11-15',10),
(1382,128,'2020-09-08',10),
(1383,181,'2020-10-11',3),
(1384,143,'2020-09-07',6),
(1385,193,'2020-05-04',6),
(1386,138,'2021-01-28',8),
(1387,133,'2020-05-17',10),
(1388,162,'2020-02-19',3),
(1389,140,'2020-08-19',8),
(1390,138,'2020-01-27',7),
(1391,151,'2020-09-25',7),
(1392,199,'2020-09-12',10),
(1393,157,'2020-03-10',3),
(1394,160,'2021-01-13',8),
(1395,148,'2020-11-04',1),
(1396,197,'2020-04-27',7),
(1397,101,'2020-10-16',1),
(1398,123,'2020-01-05',7),
(1399,129,'2020-03-05',9),
(1400,109,'2020-08-18',5),
(1401,126,'2020-04-08',1),
(1402,111,'2021-01-28',6),
(1403,100,'2020-04-14',10),
(1404,120,'2020-08-26',2),
(1405,147,'2021-03-15',3),
(1406,173,'2020-01-27',1),
(1407,162,'2020-06-09',5),
(1408,119,'2020-06-12',8),
(1409,122,'2020-03-24',2),
(1410,117,'2020-11-13',3),
(1411,143,'2020-12-08',1),
(1412,180,'2020-12-31',2),
(1413,166,'2021-03-02',10),
(1414,133,'2020-10-09',3),
(1415,142,'2021-02-14',5),
(1416,130,'2020-04-10',8),
(1417,142,'2020-03-13',2),
(1418,172,'2020-03-22',10),
(1419,141,'2020-02-02',4),
(1420,114,'2020-05-12',2),
(1421,188,'2020-08-15',10),
(1422,191,'2020-08-08',4),
(1423,128,'2021-03-29',2),
(1424,158,'2020-07-25',9),
(1425,183,'2021-03-05',9),
(1426,127,'2020-10-09',6),
(1427,183,'2021-03-21',8),
(1428,174,'2020-09-05',4),
(1429,156,'2020-08-28',3),
(1430,171,'2020-03-07',7),
(1431,149,'2021-03-19',5),
(1432,182,'2020-11-23',7),
(1433,103,'2020-11-04',1),
(1434,164,'2020-12-08',1),
(1435,108,'2020-01-23',1),
(1436,184,'2020-03-02',6),
(1437,151,'2020-12-22',2),
(1438,103,'2020-11-29',8),
(1439,149,'2021-01-30',1),
(1440,162,'2020-04-15',1),
(1441,135,'2020-09-27',10),
(1442,166,'2020-10-29',5),
(1443,166,'2020-12-04',8),
(1444,191,'2021-02-08',9),
(1445,181,'2020-07-25',9),
(1446,134,'2020-12-20',6),
(1447,141,'2020-01-16',3),
(1448,104,'2021-01-20',6),
(1449,142,'2020-01-17',7),
(1450,110,'2020-08-12',7),
(1451,118,'2021-02-23',7),
(1452,190,'2020-04-28',6),
(1453,106,'2020-10-25',10),
(1454,187,'2021-03-10',5),
(1455,183,'2020-08-03',7),
(1456,145,'2020-02-27',2),
(1457,185,'2020-04-18',4),
(1458,104,'2020-09-03',4),
(1459,173,'2020-08-03',10),
(1460,186,'2020-05-24',7),
(1461,158,'2020-06-01',3),
(1462,107,'2020-05-27',8),
(1463,100,'2020-05-01',8),
(1464,136,'2020-09-27',9),
(1465,161,'2021-02-24',7),
(1466,110,'2020-09-21',7),
(1467,183,'2020-11-11',5),
(1468,147,'2020-10-14',5),
(1469,145,'2021-01-01',10),
(1470,168,'2020-02-13',1),
(1471,142,'2020-04-01',5),
(1472,187,'2020-05-27',8),
(1473,154,'2021-03-08',10),
(1474,159,'2020-05-20',2),
(1475,150,'2020-09-11',10),
(1476,200,'2020-08-11',1),
(1477,124,'2020-03-17',5),
(1478,112,'2020-12-31',2),
(1479,119,'2020-05-08',1),
(1480,142,'2020-11-04',4),
(1481,103,'2021-03-05',1),
(1482,156,'2020-11-04',5),
(1483,159,'2020-01-05',5),
(1484,180,'2020-09-15',3),
(1485,116,'2020-08-24',10),
(1486,100,'2020-07-06',1),
(1487,141,'2021-03-25',6),
(1488,194,'2020-09-02',7),
(1489,126,'2021-01-05',10),
(1490,155,'2020-08-01',1),
(1491,154,'2020-02-23',1),
(1492,115,'2020-10-26',1),
(1493,173,'2020-04-29',2),
(1494,100,'2020-09-14',3),
(1495,178,'2020-08-31',8),
(1496,125,'2020-01-12',4),
(1497,140,'2020-03-17',8),
(1498,113,'2020-06-02',8),
(1499,143,'2020-05-29',6),
(1500,167,'2020-01-29',4),
(1501,102,'2021-03-30',5),
(1502,166,'2020-07-22',1),
(1503,167,'2020-02-04',2),
(1504,113,'2020-12-30',10),
(1505,152,'2021-01-21',7),
(1506,154,'2021-01-27',2),
(1507,174,'2020-05-31',9),
(1508,112,'2020-10-13',9),
(1509,111,'2021-02-13',3),
(1510,166,'2020-10-23',3),
(1511,145,'2020-04-07',6),
(1512,128,'2020-06-22',4),
(1513,181,'2021-01-15',7),
(1514,156,'2020-05-17',9),
(1515,134,'2021-02-04',10),
(1516,139,'2020-03-09',6),
(1517,125,'2020-06-17',10),
(1518,148,'2020-02-06',7),
(1519,156,'2021-03-05',9),
(1520,192,'2020-04-04',9),
(1521,199,'2020-07-29',2),
(1522,109,'2020-04-26',8),
(1523,137,'2021-03-15',8),
(1524,136,'2020-03-07',7),
(1525,200,'2020-10-21',8),
(1526,135,'2020-02-01',4),
(1527,100,'2020-12-04',10),
(1528,181,'2020-08-16',10),
(1529,132,'2020-05-09',1),
(1530,192,'2020-08-18',9),
(1531,144,'2020-09-28',3),
(1532,150,'2021-01-20',2),
(1533,178,'2021-01-31',9),
(1534,171,'2020-01-28',7),
(1535,173,'2020-02-16',4),
(1536,171,'2020-07-20',2),
(1537,163,'2020-11-05',8),
(1538,196,'2020-03-20',2),
(1539,153,'2020-02-17',9),
(1540,129,'2020-06-25',1),
(1541,142,'2020-10-22',1),
(1542,193,'2020-04-23',9),
(1543,151,'2020-08-26',2),
(1544,199,'2020-02-24',5),
(1545,133,'2020-06-20',9),
(1546,164,'2021-01-19',3),
(1547,141,'2020-03-29',8),
(1548,132,'2020-06-01',7),
(1549,150,'2020-09-10',4);

SELECT COUNT(*) AS TOTAL FROM SALES_FACT;

#_____________________________________________________________________________

------------- # 1. Number of Transactions by Gender a] Transactions by Men b]Transactions by Women
SELECT c.gender, COUNT(s.ORDER_ID) AS total_transactions
FROM SALES_FACT s
JOIN CUSTOMER_INFO c ON s.CUSTOMER_ID = c.CUSTOMER_ID
GROUP BY c.gender;
#having gender ='male';

----------------------#2. Number of Customers Who Have Placed an Order from More Than One Store
SELECT COUNT(DISTINCT CUSTOMER_ID) AS customer_count
FROM (
    SELECT CUSTOMER_ID
    FROM SALES_FACT
    GROUP BY CUSTOMER_ID
    HAVING COUNT(DISTINCT STORE_ID) > 1
) AS multi_store_customers;


------------------#3. City with the Highest Number of Orders
SELECT b.city, COUNT(s.ORDER_ID) AS total_orders
FROM SALES_FACT s
JOIN BRANCH_DETAILS b ON s.STORE_ID = b.STORE_ID
GROUP BY b.city
ORDER BY total_orders DESC
LIMIT 1;

----------------------#4. Area with Highest Sales (Sum of All Sales Prices)
SELECT b.city,b.area, SUM(p.SALE_PRICE * op.QUANTITY_ORDERED) AS total_sales
FROM SALES_FACT s
JOIN ORDER_PRODUCT_MAPPING op ON s.ORDER_ID = op.ORDER_ID
JOIN PRODUCT_INFO p ON op.PRODUCT_ID = p.PRODUCT_ID
JOIN BRANCH_DETAILS b ON s.STORE_ID = b.STORE_ID
GROUP BY b.area
ORDER BY total_sales DESC
LIMIT 5;

----------------------#5. State with the Highest Number of Customers
SELECT b.state, COUNT(DISTINCT s.CUSTOMER_ID) AS total_customers
FROM SALES_FACT s
JOIN BRANCH_DETAILS b ON s.STORE_ID = b.STORE_ID
GROUP BY b.state
ORDER BY total_customers DESC
LIMIT 5;

----------------#Creating Conditional Columns To segment customers into loyalty tiers based on purchase frequency:
SELECT CUSTOMER_ID,
       CASE 
           WHEN COUNT(ORDER_ID) > 5 THEN 'High-Value'
           WHEN COUNT(ORDER_ID) BETWEEN 2 AND 5 THEN 'Medium-Value'
           ELSE 'Low-Value'
       END AS loyalty_segment
FROM SALES_FACT
GROUP BY CUSTOMER_ID
order by loyalty_segment desc ;

----------------# 1. Top-Selling Products by Quantity
SELECT 
    p.Product_Name,
    SUM(om.Quantity_ordered) AS Total_Units_Sold
FROM 
    Order_product_Mapping om
JOIN 
    Product_info p ON om.Product_ID = p.Product_ID
GROUP BY 
    p.Product_Name
ORDER BY 
    Total_Units_Sold DESC
LIMIT 10;

----------------# 2. Top Revenue-Generating Products
SELECT 
    p.Product_Name,
    SUM(om.Quantity_ordered * p.sale_Price) AS Total_Revenue
FROM 
    Order_product_Mapping om
JOIN 
    Product_info p ON om.Product_ID = p.Product_ID
GROUP BY 
    p.Product_Name
ORDER BY 
    Total_Revenue DESC
LIMIT 10;