create table Drinkers (personname char(25), age numeric,astrosign char(25) );

insert into Drinkers values ('Ada',64,'cancer');
insert into Drinkers values ('John',18,'sagitarrius');
insert into Drinkers values ('George',32,'pisces');
insert into Drinkers values ('Steve',48,'aries');
insert into Drinkers values ('Willy',25,'cancer');
insert into Drinkers values ('Penelope',17,'sagitarrius');
insert into Drinkers values ('Moishe',21,'pisces');
insert into Drinkers values ('Sad Edgar',45,'aries');
insert into Drinkers values ('Codd',75,'sagitarrius');

create table Bars (barname char(25), zip numeric,dancing char(5) );

insert into Bars values ('Crocodile',98100,'Yes');
insert into Bars values ('The Pit',98125,'No');
insert into Bars values ('Biker Bar',98150,'No');
insert into Bars values ('Pink Elephant',98175,'Yes');
insert into Bars values ('Yellow Elephant',98200,'Yes');
insert into Bars values ('Smileys',98225,'No');
insert into Bars values ('Rebar',98250,'No');
insert into Bars values ('Buzzards',98275,'Yes');

create table Beers (beername char(25), price float,country char(20) );

insert into Beers values ('Bud',1,'USA');
insert into Beers values ('Heineken',3.49,'Germany');
insert into Beers values ('Rainier',2.5,'USA');
insert into Beers values ('Becks',3,'Germany');
insert into Beers values ('Samuel Adams',3.5,'USA');
insert into Beers values ('Corona',2.99,'Mexico');
insert into Beers values ('Tecate',1.98,'Mexico');


create table Frequents (personname char(25), barname char(25) );

insert into Frequents values ('Ada','Biker Bar');
insert into Frequents values ('Ada','Crocodile');
insert into Frequents values ('Ada','The Pit');
insert into Frequents values ('Codd','Pink Elephant');
insert into Frequents values ('Codd','Smileys');
insert into Frequents values ('Codd','Yellow Elephant');
insert into Frequents values ('George','Biker Bar');
insert into Frequents values ('George','Pink Elephant');
insert into Frequents values ('George','The Pit');
insert into Frequents values ('John','Pink Elephant');
insert into Frequents values ('John','Rebar');
insert into Frequents values ('John','Smileys');
insert into Frequents values ('John','Yellow Elephant');
insert into Frequents values ('Moishe','Buzzards');
insert into Frequents values ('Moishe','Crocodile');
insert into Frequents values ('Moishe','The Pit');
insert into Frequents values ('Penelope','Biker Bar');
insert into Frequents values ('Penelope','Pink Elephant');
insert into Frequents values ('Penelope','Smileys');
insert into Frequents values ('Penelope','Yellow Elephant');
insert into Frequents values ('Sad Edgar','Crocodile');
insert into Frequents values ('Sad Edgar','Rebar');
insert into Frequents values ('Steve','Buzzards');
insert into Frequents values ('Steve','Rebar');
insert into Frequents values ('Willy','Biker Bar');
insert into Frequents values ('Willy','Crocodile');
insert into Frequents values ('Willy','Rebar');
insert into Frequents values ('Willy','Smileys');
insert into Frequents values ('Willy','The Pit');
insert into Frequents values ('Willy','Yellow Elephant');


create table Likes (personname char(25), beername char(25) );

insert into Likes values ('Ada','Rainier');
insert into Likes values ('Ada','Becks');
insert into Likes values ('Codd','Samuel Adams');
insert into Likes values ('Codd','Corona');
insert into Likes values ('Codd','Bud');
insert into Likes values ('Sad Edgar','Rainier');
insert into Likes values ('Sad Edgar','Becks');
insert into Likes values ('George','Samuel Adams');
insert into Likes values ('George','Bud');
insert into Likes values ('John','Heineken');
insert into Likes values ('John','Rainier');
insert into Likes values ('John','Becks');
insert into Likes values ('Moishe','Samuel Adams');
insert into Likes values ('Moishe','Corona');
insert into Likes values ('Moishe','Bud');
insert into Likes values ('Penelope','Heineken');
insert into Likes values ('Penelope','Rainier');
insert into Likes values ('Penelope','Becks');
insert into Likes values ('Steve','Samuel Adams');
insert into Likes values ('Steve','Corona');
insert into Likes values ('Steve','Bud');


create table Sells (barname char(25), beername char(25) );

insert into Sells values ('Biker Bar','Becks');
insert into Sells values ('Biker Bar','Bud');
insert into Sells values ('Biker Bar','Corona');
insert into Sells values ('Biker Bar','Heineken');
insert into Sells values ('Biker Bar','Rainier');
insert into Sells values ('Biker Bar','Samuel Adams');
insert into Sells values ('Buzzards','Becks');
insert into Sells values ('Buzzards','Corona');
insert into Sells values ('Buzzards','Rainier');
insert into Sells values ('Buzzards','Samuel Adams');
insert into Sells values ('Buzzards','Tecate');
insert into Sells values ('Crocodile','Bud');
insert into Sells values ('Crocodile','Corona');
insert into Sells values ('Crocodile','Heineken');
insert into Sells values ('Crocodile','Samuel Adams');
insert into Sells values ('Pink Elephant','Bud');
insert into Sells values ('Pink Elephant','Heineken');
insert into Sells values ('Pink Elephant','Rainier');
insert into Sells values ('Rebar','Bud');
insert into Sells values ('Rebar','Corona');
insert into Sells values ('Rebar','Heineken');
insert into Sells values ('Rebar','Samuel Adams');
insert into Sells values ('Smileys','Corona');
insert into Sells values ('Smileys','Rainier');
insert into Sells values ('Smileys','Samuel Adams');
insert into Sells values ('The Pit','Becks');
insert into Sells values ('The Pit','Bud');
insert into Sells values ('The Pit','Corona');
insert into Sells values ('The Pit','Heineken');
insert into Sells values ('The Pit','Rainier');
insert into Sells values ('The Pit','Samuel Adams');
insert into Sells values ('Yellow Elephant','Bud');
insert into Sells values ('Yellow Elephant','Samuel Adams');
