CREATE TABLE [dbo].[Customers]([Customer_ID] [int],[Full_Name] [varchar](20) NOT NULL );
insert into Customers Values (1,'Rachel');
insert into Customers Values (2,'Kevon');
insert into Customers Values (3,'Tomas');
insert into Customers Values (4,'Dee');
insert into Customers Values (5,'Salv');
insert into Customers Values (6,'Diana');
insert into Customers Values (7,'Nicki');
insert into Customers Values (8,'Phil');
insert into Customers Values (9,'Ash');
insert into Customers Values (10,'Nadia');

CREATE TABLE [dbo].[Products]([Product_ID] [int],[Product_Name] [varchar](20) NOT NULL );
insert into Products Values (1,'Apples');
insert into Products Values (2,'Bananas');
insert into Products Values (3,'Cherries');
insert into Products Values (4,'Chicken');
insert into Products Values (5,'Eggs');
insert into Products Values (6,'Fish');
insert into Products Values (7,'Gooseberries');
insert into Products Values (8,'Ham');
insert into Products Values (9,'Ice Cream');
insert into Products Values (10,'Jalapenos');

CREATE TABLE [dbo].[Stores]([Store_ID] [int],[Store_Name] [varchar](20) NOT NULL );
insert into Stores Values (1,'Aberdeen');
insert into Stores Values (2,'Belfast');
insert into Stores Values (3,'Chester');
insert into Stores Values (4,'Doncaster');
insert into Stores Values (5,'Eastchester');
insert into Stores Values (6,'Faversham');
insert into Stores Values (7,'Grantham');
insert into Stores Values (8,'Hawkshead');
insert into Stores Values (9,'Ilkley');
insert into Stores Values (10,'Jamestown');

CREATE TABLE [dbo].[Sales]([Product_ID] [int],[Store_ID] [int], [qty_sold][int] );
insert into Sales Values (1,1,9);
insert into Sales Values (2,1,4);
insert into Sales Values (3,1,8);
insert into Sales Values (4,1,1);
insert into Sales Values (7,1,7);
insert into Sales Values (8,1,7);
insert into Sales Values (9,1,1);
insert into Sales Values (10,1,2);
insert into Sales Values (1,2,2);
insert into Sales Values (2,2,1);
insert into Sales Values (3,2,8);
insert into Sales Values (4,2,1);
insert into Sales Values (5,2,8);
insert into Sales Values (6,2,9);
insert into Sales Values (7,2,3);
insert into Sales Values (8,2,8);
insert into Sales Values (9,2,6);
insert into Sales Values (1,3,4);
insert into Sales Values (2,3,9);
insert into Sales Values (3,3,1);
insert into Sales Values (4,3,1);
insert into Sales Values (5,3,7);
insert into Sales Values (6,3,8);
insert into Sales Values (7,3,5);
insert into Sales Values (8,3,5);
insert into Sales Values (9,3,1);
insert into Sales Values (10,3,6);
insert into Sales Values (1,4,8);
insert into Sales Values (2,4,10);
insert into Sales Values (3,4,5);
insert into Sales Values (5,4,9);
insert into Sales Values (6,4,1);
insert into Sales Values (7,4,5);
insert into Sales Values (8,4,10);
insert into Sales Values (9,4,9);
insert into Sales Values (10,4,1);
insert into Sales Values (1,5,8);
insert into Sales Values (2,5,6);
insert into Sales Values (3,5,9);
insert into Sales Values (4,5,7);
insert into Sales Values (5,5,1);
insert into Sales Values (6,5,7);
insert into Sales Values (7,5,2);
insert into Sales Values (8,5,6);
insert into Sales Values (9,5,10);
insert into Sales Values (10,5,9);
insert into Sales Values (1,6,4);
insert into Sales Values (2,6,5);
insert into Sales Values (3,6,9);
insert into Sales Values (4,6,3);
insert into Sales Values (5,6,7);
insert into Sales Values (6,6,6);
insert into Sales Values (7,6,2);
insert into Sales Values (8,6,1);
insert into Sales Values (9,6,9);
insert into Sales Values (10,6,9);
insert into Sales Values (1,7,4);
insert into Sales Values (2,7,1);
insert into Sales Values (3,7,8);
insert into Sales Values (4,7,6);
insert into Sales Values (5,7,2);
insert into Sales Values (6,7,7);
insert into Sales Values (7,7,10);
insert into Sales Values (8,7,3);
insert into Sales Values (9,7,5);
insert into Sales Values (10,7,5);
insert into Sales Values (1,8,2);
insert into Sales Values (2,8,3);
insert into Sales Values (3,8,1);
insert into Sales Values (4,8,9);
insert into Sales Values (5,8,2);
insert into Sales Values (6,8,8);
insert into Sales Values (7,8,10);
insert into Sales Values (8,8,5);
insert into Sales Values (9,8,10);
insert into Sales Values (10,8,6);
insert into Sales Values (2,9,4);
insert into Sales Values (3,9,9);
insert into Sales Values (4,9,2);
insert into Sales Values (5,9,8);
insert into Sales Values (6,9,1);
insert into Sales Values (7,9,3);
insert into Sales Values (8,9,5);
insert into Sales Values (9,9,4);
insert into Sales Values (10,9,2);
insert into Sales Values (1,10,7);
insert into Sales Values (2,10,3);
insert into Sales Values (3,10,8);
insert into Sales Values (4,10,7);
insert into Sales Values (5,10,9);
insert into Sales Values (6,10,4);
insert into Sales Values (7,10,5);
insert into Sales Values (8,10,1);
insert into Sales Values (9,10,8);
insert into Sales Values (10,10,10);

CREATE TABLE [dbo].[Inventory]([Product_ID] [int],[Store_ID] [int], [stock_qty][int] );
insert into Inventory Values (1,1,9);
insert into Inventory Values (2,1,4);
insert into Inventory Values (3,1,7);
insert into Inventory Values (4,1,1);
insert into Inventory Values (5,1,5);
insert into Inventory Values (6,1,4);
insert into Inventory Values (7,1,9);
insert into Inventory Values (8,1,8);
insert into Inventory Values (10,1,9);
insert into Inventory Values (1,2,4);
insert into Inventory Values (2,2,2);
insert into Inventory Values (3,2,4);
insert into Inventory Values (4,2,5);
insert into Inventory Values (5,2,6);
insert into Inventory Values (6,2,4);
insert into Inventory Values (7,2,7);
insert into Inventory Values (8,2,9);
insert into Inventory Values (9,2,1);
insert into Inventory Values (10,2,8);
insert into Inventory Values (1,3,9);
insert into Inventory Values (2,3,8);
insert into Inventory Values (3,3,7);
insert into Inventory Values (4,3,7);
insert into Inventory Values (5,3,3);
insert into Inventory Values (6,3,8);
insert into Inventory Values (7,3,3);
insert into Inventory Values (8,3,3);
insert into Inventory Values (9,3,8);
insert into Inventory Values (10,3,7);
insert into Inventory Values (1,4,4);
insert into Inventory Values (2,4,7);
insert into Inventory Values (3,4,9);
insert into Inventory Values (4,4,1);
insert into Inventory Values (5,4,6);
insert into Inventory Values (6,4,6);
insert into Inventory Values (7,4,0);
insert into Inventory Values (8,4,4);
insert into Inventory Values (9,4,5);
insert into Inventory Values (10,4,4);
insert into Inventory Values (1,5,5);
insert into Inventory Values (2,5,5);
insert into Inventory Values (3,5,10);
insert into Inventory Values (4,5,4);
insert into Inventory Values (5,5,6);
insert into Inventory Values (6,5,5);
insert into Inventory Values (7,5,6);
insert into Inventory Values (8,5,8);
insert into Inventory Values (9,5,6);
insert into Inventory Values (10,5,4);
insert into Inventory Values (1,6,3);
insert into Inventory Values (2,6,9);
insert into Inventory Values (3,6,4);
insert into Inventory Values (4,6,9);
insert into Inventory Values (6,6,9);
insert into Inventory Values (7,6,5);
insert into Inventory Values (8,6,8);
insert into Inventory Values (9,6,9);
insert into Inventory Values (10,6,9);
insert into Inventory Values (3,7,1);
insert into Inventory Values (4,7,8);
insert into Inventory Values (5,7,5);
insert into Inventory Values (6,7,2);
insert into Inventory Values (7,7,1);
insert into Inventory Values (8,7,4);
insert into Inventory Values (9,7,5);
insert into Inventory Values (10,7,6);
insert into Inventory Values (1,8,1);
insert into Inventory Values (2,8,4);
insert into Inventory Values (3,8,6);
insert into Inventory Values (4,8,3);
insert into Inventory Values (5,8,8);
insert into Inventory Values (6,8,9);
insert into Inventory Values (7,8,5);
insert into Inventory Values (8,8,6);
insert into Inventory Values (9,8,7);
insert into Inventory Values (1,9,1);
insert into Inventory Values (2,9,2);
insert into Inventory Values (3,9,7);
insert into Inventory Values (4,9,9);
insert into Inventory Values (5,9,3);
insert into Inventory Values (6,9,9);
insert into Inventory Values (7,9,4);
insert into Inventory Values (8,9,2);
insert into Inventory Values (9,9,10);
insert into Inventory Values (2,10,7);
insert into Inventory Values (3,10,2);
insert into Inventory Values (4,10,1);
insert into Inventory Values (5,10,10);
insert into Inventory Values (6,10,1);
insert into Inventory Values (7,10,1);
insert into Inventory Values (8,10,4);
insert into Inventory Values (9,10,4);
insert into Inventory Values (10,10,1);