DROP TABLE IF EXISTS tuition;
CREATE TABLE tuition(
tuition_id VARCHAR(8) NOT NULL PRIMARY KEY
,grade INTEGER NOT NULL
);
INSERT INTO tuition(tuition_id,grade) VALUES ('10BEA100',10);
INSERT INTO tuition(tuition_id,grade) VALUES ('10BEA50',10);
INSERT INTO tuition(tuition_id,grade) VALUES ('10GR1',10);
INSERT INTO tuition(tuition_id,grade) VALUES ('10GR2',10);
INSERT INTO tuition(tuition_id,grade) VALUES ('10GR3',10);
INSERT INTO tuition(tuition_id,grade) VALUES ('11BEA100',11);
INSERT INTO tuition(tuition_id,grade) VALUES ('11BEA50',11);
INSERT INTO tuition(tuition_id,grade) VALUES ('11GR1',11);
INSERT INTO tuition(tuition_id,grade) VALUES ('11GR2',11);
INSERT INTO tuition(tuition_id,grade) VALUES ('11GR3',11);
INSERT INTO tuition(tuition_id,grade) VALUES ('12BEA100',12);
INSERT INTO tuition(tuition_id,grade) VALUES ('12BEA50',12);
INSERT INTO tuition(tuition_id,grade) VALUES ('12GR1',12);
INSERT INTO tuition(tuition_id,grade) VALUES ('12GR2',12);
INSERT INTO tuition(tuition_id,grade) VALUES ('12GR3',12);
DROP TABLE IF EXISTS tuition; CREATE TABLE tuition( tuition_id VARCHAR(8) NOT NULL PRIMARY KEY ,grade INTEGER NOT NULL ); INSERT INTO tuition(tuition_id,grade) VALUES ('10BEA100',10); INSERT INTO tuition(tuition_id,grade) VALUES ('10BEA50',10); INSERT INTO tuition(tuition_id,grade) VALUES ('10GR1',10); INSERT INTO tuition(tuition_id,grade) VALUES ('10GR2',10); INSERT INTO tuition(tuition_id,grade) VALUES ('10GR3',10); INSERT INTO tuition(tuition_id,grade) VALUES ('11BEA100',11); INSERT INTO tuition(tuition_id,grade) VALUES ('11BEA50',11); INSERT INTO tuition(tuition_id,grade) VALUES ('11GR1',11); INSERT INTO tuition(tuition_id,grade) VALUES ('11GR2',11); INSERT INTO tuition(tuition_id,grade) VALUES ('11GR3',11); INSERT INTO tuition(tuition_id,grade) VALUES ('12BEA100',12); INSERT INTO tuition(tuition_id,grade) VALUES ('12BEA50',12); INSERT INTO tuition(tuition_id,grade) VALUES ('12GR1',12); INSERT INTO tuition(tuition_id,grade) VALUES ('12GR2',12); INSERT INTO tuition(tuition_id,grade) VALUES ('12GR3',12);