CREATE TABLE pricelist (
    store character varying NOT NULL,
    beverage character varying NOT NULL,
    size integer NOT NULL,
    price money NOT NULL
);

INSERT INTO pricelist VALUES ('Plaid Pantry', 'Whole Milk', 16, '$1.15');
INSERT INTO pricelist VALUES ('Plaid Pantry', '2% Milk', 16, '$1.05');
INSERT INTO pricelist VALUES ('Plaid Pantry', 'Whole Milk', 64, '$3.20');
INSERT INTO pricelist VALUES ('Plaid Pantry', 'Pepsi', 12, '$0.70');
INSERT INTO pricelist VALUES ('Plaid Pantry', 'Diet Pepsi', 12, '$0.70');
INSERT INTO pricelist VALUES ('Plaid Pantry', 'Pepsi', 20, '$0.95');
INSERT INTO pricelist VALUES ('7-11', 'Whole Milk', 8, '$0.65');
INSERT INTO pricelist VALUES ('7-11', 'Chocolate Milk', 8, '$0.65');
INSERT INTO pricelist VALUES ('7-11', 'Whole Milk', 16, '$1.10');
INSERT INTO pricelist VALUES ('7-11', '2% Milk', 16, '$1.00');
INSERT INTO pricelist VALUES ('7-11', 'Coke', 12, '$0.65');
INSERT INTO pricelist VALUES ('7-11', 'Diet Coke', 12, '$0.65');
INSERT INTO pricelist VALUES ('7-11', 'Coke', 20, '$1.10');
INSERT INTO pricelist VALUES ('7-11', 'Diet Coke', 20, '$1.10');
INSERT INTO pricelist VALUES ('7-11', 'Diet Caffeine-Free Cherry Coke', 20, '$1.10');
INSERT INTO pricelist VALUES ('Circle K', 'Whole Milk', 8, '$0.60');
INSERT INTO pricelist VALUES ('Circle K', 'Whole Milk', 16, '$1.20');
INSERT INTO pricelist VALUES ('Circle K', 'Whole Milk', 32, '$2.30');
INSERT INTO pricelist VALUES ('Circle K', 'Whole Milk', 128, '$4.10');
INSERT INTO pricelist VALUES ('Circle K', 'Coke', 20, '$1.15');
INSERT INTO pricelist VALUES ('Circle K', 'Diet Coke', 20, '$1.15');
INSERT INTO pricelist VALUES ('Circle K', 'Coke', 32, '$2.10');
INSERT INTO pricelist VALUES ('Circle K', 'Diet Coke', 32, '$2.05');
INSERT INTO pricelist VALUES ('Safeway', 'Skim Milk', 16, '$1.20');
INSERT INTO pricelist VALUES ('Safeway', 'Skim Milk', 32, '$2.00');
INSERT INTO pricelist VALUES ('Safeway', '2% Milk', 16, '$1.25');
INSERT INTO pricelist VALUES ('Safeway', '2% Milk', 64, '$2.75');
INSERT INTO pricelist VALUES ('Safeway', 'Diet Pepsi', 12, '$0.60');
INSERT INTO pricelist VALUES ('Safeway', 'Diet Coke', 12, '$0.60');

