-- Insert records into sample database of Stores, Buyers, Sells, Sneakers
-- Sneakers
insert into Sneakers values('Nike', 'M One');
insert into Sneakers values('Adidas', 'N Two');
insert into Sneakers values('AirJordan', 'A Three');

-- Stores
insert into Stores values('Lewisburg', '123 Market Stret', 'Jane');
insert into Stores values('Danville', '123 Main Stret', 'Mary');
insert into Stores values('Shamokin', '456 Market Stret', 'Mike');

-- Buyers
insert into Buyers values('Alice', '123 Side Stret', '123-456-8888');
insert into Buyers values('Bob', '456 Off Stret', '456-123-6666');
insert into Buyers values('Caitlin', '222 Johns Stret', '888-123-4567');
insert into Buyers values('David', '666 Small Stret', '666-456-1234');

-- Sells
insert into Sells values('Lewisburg', 'Nike', 45.0);
insert into Sells values('Lewisburg', 'Adidas', 40.0);
insert into Sells values('Lewisburg', 'AirJordan', 48.0);
insert into Sells values('Danville', 'Nike', 48.0);
insert into Sells values('Danville', 'Adidas', 40);
insert into Sells values('Danville', 'AirJordan', 42);
insert into Sells values('Shamokin', 'Nike', 39);
insert into Sells values('Shamokin', 'Adidas', 42);
insert into Sells values('Shamokin', 'AirJordan', 50);
insert into Sells values('Joe''s Store', 'Nike', 48);
insert into Sells values('Joe''s Store', 'Adidas', 48);
insert into Sells values('Joe''s Store', 'AirJordan', 48);

-- Likes
insert into Likes values('Alice', 'Nike');
insert into Likes values('Alice', 'AirJordan');
insert into Likes values('Bob', 'AirJordan');
insert into Likes values('Caitlin', 'Nike');
insert into Likes values('Caitlin', 'Adidas');

-- BuysAt
insert into BuysAt values('Alice', 'Lewisburg');
insert into BuysAt values('Alice', 'Danville');
insert into BuysAt values('Caitlin', 'Shamokin');



