DROP TABLE BAE;
CREATE TABLE BAE(TEAM VARCHAR2(2), VAL VARCHAR2(2));
ALTER TABLE BAE ADD PRIMARY KEY(TEAM,VAL);
INSERT INTO BAE (TEAM,VAL) VALUES ('TM', 'A');
INSERT INTO BAE (TEAM,VAL) VALUES ('TM', 'B');
INSERT INTO BAE (TEAM,VAL) VALUES ('TM', 'C');
INSERT INTO BAE (TEAM,VAL) VALUES ('DT', 'D');
INSERT INTO BAE (TEAM,VAL) VALUES ('DT', 'E');
INSERT INTO BAE (TEAM,VAL) VALUES ('DT', 'F');
INSERT INTO BAE (TEAM,VAL) VALUES ('HS', 'A');
INSERT INTO BAE (TEAM,VAL) VALUES ('HS', 'E');
INSERT INTO BAE (TEAM,VAL) VALUES ('HS', 'F');