CREATE TABLE Zone (
	Name VARCHAR(12),
	PriceMultiplier FLOAT NOT NULL,
	PRIMARY KEY (Name)
);

INSERT INTO Zone VALUES ('rear stalls', 1.00);
INSERT INTO Zone VALUES ('front stalls', 1.50);
INSERT INTO Zone VALUES ('balcony', 1.80);
INSERT INTO Zone VALUES ('box 1', 5.00);
INSERT INTO Zone VALUES ('box 2', 5.00);
INSERT INTO Zone VALUES ('box 3', 4.00);
INSERT INTO Zone VALUES ('box 4', 4.00);