
DROP TABLE IF EXISTS olympics;
CREATE TABLE olympics (pos INTEGER, country VARCHAR(20), medal VARCHAR(20), count INTEGER);

INSERT INTO olympics VALUES (1,'USA','gold',   39);
INSERT INTO olympics VALUES (1,'USA','silver', 41);
INSERT INTO olympics VALUES (1,'USA','bronze', 33);

INSERT INTO olympics VALUES (2,'CHINA','gold',   38);
INSERT INTO olympics VALUES (2,'CHINA','silver', 32);
INSERT INTO olympics VALUES (2,'CHINA','bronze', 18);

INSERT INTO olympics VALUES (3,'JAPAN','gold',   27);
INSERT INTO olympics VALUES (3,'JAPAN','silver', 14);
INSERT INTO olympics VALUES (3,'JAPAN','bronze', 17);

INSERT INTO olympics VALUES (4,'UK','gold',   22);
INSERT INTO olympics VALUES (4,'UK','silver', 21);
INSERT INTO olympics VALUES (4,'UK','bronze', 22);

INSERT INTO olympics VALUES (5,'ROC','gold',   20);
INSERT INTO olympics VALUES (5,'ROC','silver', 28);
INSERT INTO olympics VALUES (5,'ROC','bronze', 23);

