-- If you want to re-run this script after already having a Beers table,
-- you can un-comment the next line.
-- drop table beers;

create table Beers (
    id integer primary key,
    quantity integer not null,
    rating integer not null,
    name varchar2(50) not null,
    rank number default null
);

insert into Beers values( 1,  1, 100, 'New Glarus Belgian Red', null);
insert into Beers values( 2,  1,  99, 'New Glarus Raspberry Tart', null);
insert into Beers values( 3, 23,  97, 'Duvel', null);
insert into Beers values( 4,  2,  93, 'Verhaeghe Duchesse De Bourgogne', null);
insert into Beers values( 5,  8,  93, 'Ommegang Hennepin', null);
insert into Beers values( 6,  1,  95, 'New Glarus Apple Ale', null);
insert into Beers values( 7,  4,  99, 'Victory Old Horizontal', null);
insert into Beers values( 8,  5,  97, 'Victory HopDevil', null);
insert into Beers values( 9,  5,  99, 'Two Hearted Ale', null);
insert into Beers values(10,  5,  86, 'New Holland The Poet', null);
insert into Beers values(11,  4,  99, 'Third Coast Old Ale', null);
insert into Beers values(12,  2, 100, 'North Coast Old Rasputin Russian Imperial Stout', null);
insert into Beers values(13,  2,  98, 'Flying Dog Gonzo Imperial Porter', null);
insert into Beers values(14,  7,  99, 'Bells Kalamazoo Stout', null);
insert into Beers values(15,  4,  93, 'Bells Porter', null);