--
-- SCHEMA
--
DROP SCHEMA IF EXISTS games CASCADE;

CREATE SCHEMA games;


-- NOC represents the international code for the country
-- for instance, 'CAN' is the NOC for 'Canada'
create table games.country (
    NOC char(3) not null,
    ctName char(15) not null,
    primary key (NOC) );

-- year represents the year when this Olympics took place
create table games.olympics (
    oID int not null, 
    year int not null, 
    primary key (oID) );

create table games.venue (
    vID int not null, 
    vName char(20) not null, 
    capacity int not null,
    primary key (vID) );


-- sID represents the ID of the sport
-- sName represents the name of the sport
-- year represents the year when this sport became an Olympic sport
create table games.sport ( 
    sID int not null, 
    sName char(20) not null,
    year int not null,
    primary key (sID) );


-- date represents the date when the competition took place
-- sID represents the ID of the sport the competition is
-- associated to
-- vID represents the ID of the Venue where the competition
-- took place
-- type represents the type of the competition ('q'uals,
-- 's'emifinal, and 'f'inal)
create table games.competition (
    cID int not null,
    cName char(30) not null, 
    sID int not null, 
    vID int not null, 
    date DATE not null, 
    type char(1) not null check (type in ('q', 's', 'f')), 
    foreign key (sID) references games.sport on delete cascade, 
    foreign key (vID) references games.venue on delete cascade, 
    primary key (cID), 
    unique (cName) );


-- start and end represent the dates when the athlete competed in the
-- Olympics for the first and last time, respectively
create table games.athlete ( 
    aID int not null, 
    aName char(20) not null, 
    NOC char(3) not null, 
    dob DATE not null, 
    start DATE not null,
    finish DATE not null, 
    foreign key (NOC) references games.country on delete cascade, 
    primary key (aID));

-- the rank (final standings) an athlete obtained in a competition
create table games.results ( 
    cID int not null, 
    aID int not null, 
    rank int not null, 
    foreign key (cID) references games.competition on delete cascade, 
    foreign key (aID) references games.athlete on delete cascade, 
    primary key (cID, aID) );


--
-- DATA
--

-- country: 
-- --------
insert into games.country values('001', 'country001');
insert into games.country values('002', 'country002');
insert into games.country values('003', 'country003');

-- just participated in olympic 98
insert into games.country values('004', 'country004');

 -- has not participated in any olympic
insert into games.country values('005', 'country005');



-- olympics:
-- ---------
insert into games.olympics values( 6, 2006);
insert into games.olympics values( 2, 2002);
insert into games.olympics values(98, 1998);

-- venue: 3 per olympic
-- --------------------

-- for olympic 1998
insert into games.venue values( 980001, '1998_V01', 100);
insert into games.venue values( 980002, '1998_V02', 200);
insert into games.venue values( 980003, '1998_V03', 300);

-- for olympic 2002
insert into games.venue values(  20001, '2002_V01', 200);
insert into games.venue values(  20002, '2002_V02', 500);
insert into games.venue values(  20003, '2002_V03', 400);


 -- for olympic 2006
insert into games.venue values(  60001, '2006_V01', 500);
insert into games.venue values(  60002, '2006_V02', 700);
insert into games.venue values(  60003, '2006_V03', 100);

-- sport:
-- ------
insert into games.sport values( 1, 'sport01', 1940);
insert into games.sport values( 2, 'sport02', 1940);
insert into games.sport values( 3, 'sport03', 1940);
insert into games.sport values( 4, 'sport04', 1940);
insert into games.sport values( 5, 'sport05', 1940);
insert into games.sport values( 6, 'sport06', 1940);
insert into games.sport values( 7, 'sport07', 1940);
insert into games.sport values( 8, 'sport08', 1940);
insert into games.sport values( 9, 'sport09', 1940);


 -- in no venue
insert into games.sport values( 10, 'sport10', 1940);

 -- Only one venue (980002)
insert into games.sport values( 11, 'sport11', 1940);

-- two venue with the same capacity (980001, 60003)
insert into games.sport values( 12, 'sport12', 1940);

-- competition:
-- ------------
--                              cID       CName       sID vID     date          type
--                              --------  ----------  --- ------  ------------  ---

-- for olympic 1998
insert into games.competition values( 98000011, '1998_C11',  1, 980001, '1998-06-10', 'q'); 
insert into games.competition values( 98000012, '1998_C12',  1, 980001, '1998-06-11', 's');
insert into games.competition values( 98000013, '1998_C13',  1, 980001, '1998-06-12', 'f');

insert into games.competition values( 98000021, '1998_C21',  2, 980001, '1998-06-10', 'q');
insert into games.competition values( 98000022, '1998_C22',  2, 980001, '1998-06-11', 's');
insert into games.competition values( 98000023, '1998_C23',  2, 980001, '1998-06-12', 'f');

insert into games.competition values( 98000031, '1998_C31',  3, 980001, '1998-06-10', 'q');
insert into games.competition values( 98000032, '1998_C32',  3, 980001, '1998-06-11', 's');
insert into games.competition values( 98000033, '1998_C33',  3, 980001, '1998-06-12', 'f');

insert into games.competition values( 98000041, '1998_C41',  4, 980002, '1998-06-10', 'q');
insert into games.competition values( 98000042, '1998_C42',  4, 980002, '1998-06-11', 's');
insert into games.competition values( 98000043, '1998_C43',  4, 980002, '1998-06-12', 'f');

insert into games.competition values( 98000051, '1998_C51',  5, 980002, '1998-06-10', 'q');
insert into games.competition values( 98000052, '1998_C52',  5, 980002, '1998-06-11', 's');
insert into games.competition values( 98000053, '1998_C53',  5, 980002, '1998-06-12', 'f');

insert into games.competition values( 98000061, '1998_C61',  6, 980002, '1998-06-10', 'q');
insert into games.competition values( 98000062, '1998_C62',  6, 980002, '1998-06-11', 's');
insert into games.competition values( 98000063, '1998_C63',  6, 980002, '1998-06-12', 'f');

insert into games.competition values( 98000071, '1998_C71',  7, 980003, '1998-06-10', 'q');
insert into games.competition values( 98000072, '1998_C72',  7, 980003, '1998-06-11', 's');
insert into games.competition values( 98000073, '1998_C73',  7, 980003, '1998-06-12', 'f');

insert into games.competition values( 98000081, '1998_C81',  8, 980003, '1998-06-10', 'q');
insert into games.competition values( 98000082, '1998_C82',  8, 980003, '1998-06-11', 's');
insert into games.competition values( 98000083, '1998_C83',  8, 980003, '1998-06-12', 'f');

insert into games.competition values( 98000091, '1998_C91',  9, 980003, '1998-06-10', 'q');
insert into games.competition values( 98000092, '1998_C92',  9, 980003, '1998-06-11', 's');
insert into games.competition values( 98000093, '1998_C93',  9, 980003, '1998-06-12', 'f');


-- for olympic 2002
insert into games.competition values(  2000011, '2002_C11',  1,  20001, '2002-06-10', 'q');
insert into games.competition values(  2000012, '2002_C12',  1,  20001, '2002-06-11', 's');
insert into games.competition values(  2000013, '2002_C13',  1,  20001, '2002-06-12', 'f');

insert into games.competition values(  2000021, '2002_C21',  2,  20001, '2002-06-10', 'q');
insert into games.competition values(  2000022, '2002_C22',  2,  20001, '2002-06-11', 's');
insert into games.competition values(  2000023, '2002_C23',  2,  20001, '2002-06-12', 'f');

insert into games.competition values(  2000031, '2002_C31',  3,  20001, '2002-06-10', 'q');
insert into games.competition values(  2000032, '2002_C32',  3,  20001, '2002-06-11', 's');
insert into games.competition values(  2000033, '2002_C33',  3,  20001, '2002-06-12', 'f');

insert into games.competition values(  2000041, '2002_C41',  4,  20002, '2002-06-10', 'q');
insert into games.competition values(  2000042, '2002_C42',  4,  20002, '2002-06-11', 's');
insert into games.competition values(  2000043, '2002_C43',  4,  20002, '2002-06-12', 'f');

insert into games.competition values(  2000051, '2002_C51',  5,  20002, '2002-06-10', 'q');
insert into games.competition values(  2000052, '2002_C52',  5,  20002, '2002-06-11', 's');
insert into games.competition values(  2000053, '2002_C53',  5,  20002, '2002-06-12', 'f');

insert into games.competition values(  2000061, '2002_C61',  6,  20002, '2002-06-10', 'q');
insert into games.competition values(  2000062, '2002_C62',  6,  20002, '2002-06-11', 's');
insert into games.competition values(  2000063, '2002_C63',  6,  20002, '2002-06-12', 'f');

insert into games.competition values(  2000071, '2002_C71',  7,  20003, '2002-06-10', 'q');
insert into games.competition values(  2000072, '2002_C72',  7,  20003, '2002-06-11', 's');
insert into games.competition values(  2000073, '2002_C73',  7,  20003, '2002-06-12', 'f');

insert into games.competition values(  2000081, '2002_C81',  8,  20003, '2002-06-10', 'q');
insert into games.competition values(  2000082, '2002_C82',  8,  20003, '2002-06-11', 's');
insert into games.competition values(  2000083, '2002_C83',  8,  20003, '2002-06-12', 'f');

insert into games.competition values(  2000091, '2002_C91',  9,  20003, '2002-06-10', 'q');
insert into games.competition values(  2000092, '2002_C92',  9,  20003, '2002-06-11', 's');
insert into games.competition values(  2000093, '2002_C93',  9,  20003, '2002-06-12', 'f');


-- for olympic 2006
insert into games.competition values(  6000011, '2006_C11',  1,  60001, '2006-06-10', 'q');
insert into games.competition values(  6000012, '2006_C12',  1,  60001, '2006-06-11', 's');
insert into games.competition values(  6000013, '2006_C13',  1,  60001, '2006-06-12', 'f');

insert into games.competition values(  6000021, '2006_C21',  2,  60001, '2006-06-10', 'q');
insert into games.competition values(  6000022, '2006_C22',  2,  60001, '2006-06-11', 's');
insert into games.competition values(  6000023, '2006_C23',  2,  60001, '2006-06-12', 'f');

insert into games.competition values(  6000031, '2006_C31',  3,  60001, '2006-06-10', 'q');
insert into games.competition values(  6000032, '2006_C32',  3,  60001, '2006-06-11', 's');
insert into games.competition values(  6000033, '2006_C33',  3,  60001, '2006-06-12', 'f');

insert into games.competition values(  6000041, '2006_C41',  4,  60002, '2006-06-10', 'q');
insert into games.competition values(  6000042, '2006_C42',  4,  60002, '2006-06-11', 's');
insert into games.competition values(  6000043, '2006_C43',  4,  60002, '2006-06-12', 'f');

insert into games.competition values(  6000051, '2006_C51',  5,  60002, '2006-06-10', 'q');
insert into games.competition values(  6000052, '2006_C52',  5,  60002, '2006-06-11', 's');
insert into games.competition values(  6000053, '2006_C53',  5,  60002, '2006-06-12', 'f');

insert into games.competition values(  6000061, '2006_C61',  6,  60002, '2006-06-10', 'q');
insert into games.competition values(  6000062, '2006_C62',  6,  60002, '2006-06-11', 's');
insert into games.competition values(  6000063, '2006_C63',  6,  60002, '2006-06-12', 'f');

insert into games.competition values(  6000071, '2006_C71',  7,  60003, '2006-06-10', 'q');
insert into games.competition values(  6000072, '2006_C72',  7,  60003, '2006-06-11', 's');
insert into games.competition values(  6000073, '2006_C73',  7,  60003, '2006-06-12', 'f');

insert into games.competition values(  6000081, '2006_C81',  8,  60003, '2006-06-10', 'q');
insert into games.competition values(  6000082, '2006_C82',  8,  60003, '2006-06-11', 's');
insert into games.competition values(  6000083, '2006_C83',  8,  60003, '2006-06-12', 'f');

insert into games.competition values(  6000091, '2006_C91',  9,  60003, '2006-06-10', 'q');
insert into games.competition values(  6000092, '2006_C92',  9,  60003, '2006-06-11', 's');
insert into games.competition values(  6000093, '2006_C93',  9,  60003, '2006-06-12', 'f');

insert into games.competition values( 980000111, '1998_C111',  11, 980002, '1998-06-10', 'q');
insert into games.competition values( 980000121, '1998_C121',  12, 980001, '1998-06-10', 'q');
insert into games.competition values(  60000121, '2006_C121',  12,  60003, '2006-06-10', 'q');

-- athlete:
-- --------

-- for country '001'
insert into games.athlete values(101, 'A_001_01', '001', '1981-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(102, 'A_001_02', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(103, 'A_001_03', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(104, 'A_001_04', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(105, 'A_001_05', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(106, 'A_001_06', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(107, 'A_001_07', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(108, 'A_001_08', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(109, 'A_001_09', '001', '1980-01-01', '1990-01-01', '2020-01-01');

insert into games.athlete values(110, 'A_001_10', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(111, 'A_001_11', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(112, 'A_001_12', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(113, 'A_001_13', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(114, 'A_001_14', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(115, 'A_001_15', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(116, 'A_001_16', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(117, 'A_001_17', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(118, 'A_001_18', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(119, 'A_001_19', '001', '1980-01-01', '1990-01-01', '2020-01-01');

insert into games.athlete values(120, 'A_001_20', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(121, 'A_001_21', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(122, 'A_001_22', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(123, 'A_001_23', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(124, 'A_001_24', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(125, 'A_001_25', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(126, 'A_001_26', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(127, 'A_001_27', '001', '1981-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(128, 'A_001_28', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(129, 'A_001_29', '001', '1980-01-01', '1990-01-01', '2020-01-01');

insert into games.athlete values(130, 'A_001_30', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(131, 'A_001_31', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(132, 'A_001_32', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(133, 'A_001_33', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(134, 'A_001_34', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(135, 'A_001_35', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(136, 'A_001_36', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(137, 'A_001_37', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(138, 'A_001_38', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(139, 'A_001_39', '001', '1980-01-01', '1990-01-01', '2020-01-01');

insert into games.athlete values(140, 'A_001_40', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(141, 'A_001_41', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(142, 'A_001_42', '001', '1981-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(143, 'A_001_43', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(144, 'A_001_44', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(145, 'A_001_45', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(146, 'A_001_46', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(147, 'A_001_47', '001', '1981-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(148, 'A_001_48', '001', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(149, 'A_001_49', '001', '1980-01-01', '1990-01-01', '2020-01-01');

insert into games.athlete values(150, 'A_001_50', '001', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(151, 'A_001_51', '001', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(152, 'A_001_52', '001', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(153, 'A_001_53', '001', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(154, 'A_001_54', '001', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(155, 'A_001_55', '001', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(156, 'A_001_56', '001', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(157, 'A_001_57', '001', '1970-01-01', '1990-01-01', '2020-01-01');

-- for country '002'
insert into games.athlete values(201, 'A_002_01', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(202, 'A_002_02', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(203, 'A_002_03', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(204, 'A_002_04', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(205, 'A_002_05', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(206, 'A_002_06', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(207, 'A_002_07', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(208, 'A_002_08', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(209, 'A_002_09', '002', '1980-01-01', '1990-01-01', '2020-01-01');

insert into games.athlete values(210, 'A_002_10', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(211, 'A_002_11', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(212, 'A_002_12', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(213, 'A_002_13', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(214, 'A_002_14', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(215, 'A_002_15', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(216, 'A_002_16', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(217, 'A_002_17', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(218, 'A_002_18', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(219, 'A_002_19', '002', '1980-01-01', '1990-01-01', '2020-01-01');

insert into games.athlete values(220, 'A_002_20', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(221, 'A_002_21', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(222, 'A_002_22', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(223, 'A_002_23', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(224, 'A_002_24', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(225, 'A_002_25', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(226, 'A_002_26', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(227, 'A_002_27', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(228, 'A_002_28', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(229, 'A_002_29', '002', '1980-01-01', '1990-01-01', '2020-01-01');

insert into games.athlete values(230, 'A_002_30', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(231, 'A_002_31', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(232, 'A_002_32', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(233, 'A_002_33', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(234, 'A_002_34', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(235, 'A_002_35', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(236, 'A_002_36', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(237, 'A_002_37', '002', '1981-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(238, 'A_002_38', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(239, 'A_002_39', '002', '1980-01-01', '1990-01-01', '2020-01-01');

insert into games.athlete values(240, 'A_002_40', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(241, 'A_002_41', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(242, 'A_002_42', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(243, 'A_002_43', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(244, 'A_002_44', '002', '1981-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(245, 'A_002_45', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(246, 'A_002_46', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(247, 'A_002_47', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(248, 'A_002_48', '002', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(249, 'A_002_49', '002', '1980-01-01', '1990-01-01', '2020-01-01');

insert into games.athlete values(250, 'A_002_50', '002', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(251, 'A_002_51', '002', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(252, 'A_002_52', '002', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(253, 'A_002_53', '002', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(254, 'A_002_54', '002', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(255, 'A_002_55', '002', '1970-01-01', '1990-01-01', '2020-01-01');




-- for country '003'
insert into games.athlete values(301, 'A_003_01', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(302, 'A_003_02', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(303, 'A_003_03', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(304, 'A_003_04', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(305, 'A_003_05', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(306, 'A_003_06', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(307, 'A_003_07', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(308, 'A_003_08', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(309, 'A_003_09', '003', '1980-01-01', '1990-01-01', '2020-01-01');

insert into games.athlete values(310, 'A_003_10', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(311, 'A_003_11', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(312, 'A_003_12', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(313, 'A_003_13', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(314, 'A_003_14', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(315, 'A_003_15', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(316, 'A_003_16', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(317, 'A_003_17', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(318, 'A_003_18', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(319, 'A_003_19', '003', '1980-01-01', '1990-01-01', '2020-01-01');

insert into games.athlete values(320, 'A_003_20', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(321, 'A_003_21', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(322, 'A_003_22', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(323, 'A_003_23', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(324, 'A_003_24', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(325, 'A_003_25', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(326, 'A_003_26', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(327, 'A_003_27', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(328, 'A_003_28', '003', '1981-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(329, 'A_003_29', '003', '1980-01-01', '1990-01-01', '2020-01-01');

insert into games.athlete values(330, 'A_003_30', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(331, 'A_003_31', '003', '1981-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(332, 'A_003_32', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(333, 'A_003_33', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(334, 'A_003_34', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(335, 'A_003_35', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(336, 'A_003_36', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(337, 'A_003_37', '003', '1982-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(338, 'A_003_38', '003', '1981-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(339, 'A_003_39', '003', '1980-01-01', '1990-01-01', '2020-01-01');

insert into games.athlete values(340, 'A_003_40', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(341, 'A_003_41', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(342, 'A_003_42', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(343, 'A_003_43', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(344, 'A_003_44', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(345, 'A_003_45', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(346, 'A_003_46', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(347, 'A_003_47', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(348, 'A_003_48', '003', '1980-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(349, 'A_003_49', '003', '1980-01-01', '1990-01-01', '2020-01-01');

insert into games.athlete values(350, 'A_003_50', '003', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(351, 'A_003_51', '003', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(352, 'A_003_52', '003', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(353, 'A_003_53', '003', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(354, 'A_003_54', '003', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(355, 'A_003_55', '003', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(356, 'A_003_56', '003', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(357, 'A_003_57', '003', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(358, 'A_003_58', '003', '1970-01-01', '1990-01-01', '2020-01-01');

-- for country '004'
insert into games.athlete values(401, 'A_004_01', '004', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(402, 'A_004_02', '004', '1970-01-01', '1990-01-01', '2020-01-01');
insert into games.athlete values(403, 'A_004_03', '004', '1970-01-01', '1990-01-01', '2020-01-01');


-- results:
-- --------

-- for olympic 1998 


-- competition 1 - q

insert into games.results values( 98000011, 101, 1); 
insert into games.results values( 98000011, 201, 2);
insert into games.results values( 98000011, 102, 3);
insert into games.results values( 98000011, 202, 4);
insert into games.results values( 98000011, 103, 5);
insert into games.results values( 98000011, 203, 6); 
insert into games.results values( 98000011, 104, 7);
insert into games.results values( 98000011, 204, 8);
insert into games.results values( 98000011, 105, 9);

insert into games.results values( 98000011, 205, 10); 
insert into games.results values( 98000011, 106, 11);
insert into games.results values( 98000011, 206, 12);
insert into games.results values( 98000011, 107, 13);
insert into games.results values( 98000011, 207, 14);
insert into games.results values( 98000011, 108, 15); 
insert into games.results values( 98000011, 301, 16);
insert into games.results values( 98000011, 109, 17);
insert into games.results values( 98000011, 302, 18);
insert into games.results values( 98000011, 110, 19);

insert into games.results values( 98000011, 208, 20); 
insert into games.results values( 98000011, 111, 21);
insert into games.results values( 98000011, 303, 22);
insert into games.results values( 98000011, 112, 23);
insert into games.results values( 98000011, 304, 24);
insert into games.results values( 98000011, 113, 25); 
insert into games.results values( 98000011, 305, 26);
insert into games.results values( 98000011, 114, 27);
insert into games.results values( 98000011, 209, 28);
insert into games.results values( 98000011, 306, 29);

insert into games.results values( 98000011, 210, 30); 
insert into games.results values( 98000011, 307, 31);
insert into games.results values( 98000011, 211, 32);
insert into games.results values( 98000011, 308, 33);
insert into games.results values( 98000011, 212, 34);
insert into games.results values( 98000011, 309, 35); 
insert into games.results values( 98000011, 213, 36);
insert into games.results values( 98000011, 310, 37);
insert into games.results values( 98000011, 311, 38);
insert into games.results values( 98000011, 312, 39);

insert into games.results values( 98000011, 214, 40); 
insert into games.results values( 98000011, 313, 41);
insert into games.results values( 98000011, 314, 42);
insert into games.results values( 98000011, 315, 43);
insert into games.results values( 98000011, 316, 44);
insert into games.results values( 98000011, 150, 45);
insert into games.results values( 98000011, 248, 46);
insert into games.results values( 98000011, 151, 47);
insert into games.results values( 98000011, 249, 48);
insert into games.results values( 98000011, 152, 49);

insert into games.results values( 98000011, 250, 50);
insert into games.results values( 98000011, 153, 51);
insert into games.results values( 98000011, 251, 52);
insert into games.results values( 98000011, 154, 53);
insert into games.results values( 98000011, 252, 54);
insert into games.results values( 98000011, 155, 55);
insert into games.results values( 98000011, 253, 56);
insert into games.results values( 98000011, 156, 57);
insert into games.results values( 98000011, 254, 58);
insert into games.results values( 98000011, 157, 59);

insert into games.results values( 98000011, 255, 60);

insert into games.results values( 98000011, 401, 61);
insert into games.results values( 98000011, 402, 62);

insert into games.results values( 98000011, 349, 63);


-- competition 1 - s

insert into games.results values( 98000012, 301, 1); 
insert into games.results values( 98000012, 201, 2);
insert into games.results values( 98000012, 101, 3);
insert into games.results values( 98000012, 302, 4);
insert into games.results values( 98000012, 202, 5);
insert into games.results values( 98000012, 303, 6);
insert into games.results values( 98000012, 102, 7);
insert into games.results values( 98000012, 305, 8);
insert into games.results values( 98000012, 203, 9);

insert into games.results values( 98000012, 103, 10); 
insert into games.results values( 98000012, 315, 11);
insert into games.results values( 98000012, 204, 12);
insert into games.results values( 98000012, 104, 13);
insert into games.results values( 98000012, 306, 14);
insert into games.results values( 98000012, 205, 15);
insert into games.results values( 98000012, 105, 16);
insert into games.results values( 98000012, 307, 17);
insert into games.results values( 98000012, 206, 18);
insert into games.results values( 98000012, 308, 19);

insert into games.results values( 98000012, 207, 20); 
insert into games.results values( 98000012, 309, 21);
insert into games.results values( 98000012, 106, 22);
insert into games.results values( 98000012, 208, 23);
insert into games.results values( 98000012, 107, 24);
insert into games.results values( 98000012, 209, 25);
insert into games.results values( 98000012, 108, 26);
insert into games.results values( 98000012, 109, 27);
insert into games.results values( 98000012, 110, 28);

-- competition 1 - f

insert into games.results values( 98000013, 201, 1); 
insert into games.results values( 98000013, 101, 2);
insert into games.results values( 98000013, 301, 3);
insert into games.results values( 98000013, 202, 4);
insert into games.results values( 98000013, 102, 5);
insert into games.results values( 98000013, 302, 6);
insert into games.results values( 98000013, 203, 7);
insert into games.results values( 98000013, 303, 8);
insert into games.results values( 98000013, 103, 9);

insert into games.results values( 98000013, 304, 10);
insert into games.results values( 98000013, 204, 11);
insert into games.results values( 98000013, 104, 12);
insert into games.results values( 98000013, 305, 13);
insert into games.results values( 98000013, 306, 14);


-- competition 2 - q

insert into games.results values( 98000021, 215, 1); 
insert into games.results values( 98000021, 328, 2);
insert into games.results values( 98000021, 115, 3);
insert into games.results values( 98000021, 317, 4);
insert into games.results values( 98000021, 216, 5);
insert into games.results values( 98000021, 116, 6);
insert into games.results values( 98000021, 318, 7);
insert into games.results values( 98000021, 217, 8);
insert into games.results values( 98000021, 117, 9);

insert into games.results values( 98000021, 218, 10);
insert into games.results values( 98000021, 319, 11);
insert into games.results values( 98000021, 118, 12);
insert into games.results values( 98000021, 320, 13);
insert into games.results values( 98000021, 219, 14);
insert into games.results values( 98000021, 321, 15);
insert into games.results values( 98000021, 119, 16);
insert into games.results values( 98000021, 220, 17);
insert into games.results values( 98000021, 322, 18);
insert into games.results values( 98000021, 120, 19);

insert into games.results values( 98000021, 221, 20);
insert into games.results values( 98000021, 323, 21);
insert into games.results values( 98000021, 121, 22);
insert into games.results values( 98000021, 222, 23);
insert into games.results values( 98000021, 122, 24);
insert into games.results values( 98000021, 223, 25);
insert into games.results values( 98000021, 123, 26);
insert into games.results values( 98000021, 324, 27);
insert into games.results values( 98000021, 124, 28);
insert into games.results values( 98000021, 224, 29);

insert into games.results values( 98000021, 225, 30);
insert into games.results values( 98000021, 125, 31);
insert into games.results values( 98000021, 226, 32);
insert into games.results values( 98000021, 126, 33);
insert into games.results values( 98000021, 325, 34);
insert into games.results values( 98000021, 326, 35);
insert into games.results values( 98000021, 327, 36);

insert into games.results values( 98000021, 403, 37);



-- competition 2 - s

insert into games.results values( 98000022, 115, 1); 
insert into games.results values( 98000022, 215, 2);
insert into games.results values( 98000022, 328, 3);
insert into games.results values( 98000022, 116, 4);
insert into games.results values( 98000022, 216, 5);
insert into games.results values( 98000022, 117, 6);
insert into games.results values( 98000022, 317, 7);
insert into games.results values( 98000022, 217, 8);
insert into games.results values( 98000022, 118, 9);

-- competition 2 - f

insert into games.results values( 98000023, 117, 1); 
insert into games.results values( 98000023, 216, 2);
insert into games.results values( 98000023, 328, 3);
insert into games.results values( 98000023, 115, 4);
insert into games.results values( 98000023, 317, 5);
insert into games.results values( 98000023, 217, 6);
insert into games.results values( 98000023, 116, 7);


-- competition 3 - q

insert into games.results values( 98000031, 127, 1); 
insert into games.results values( 98000031, 329, 2);
insert into games.results values( 98000031, 227, 3);
insert into games.results values( 98000031, 128, 4);
insert into games.results values( 98000031, 330, 5);
insert into games.results values( 98000031, 228, 6);
insert into games.results values( 98000031, 129, 7);
insert into games.results values( 98000031, 232, 8);
insert into games.results values( 98000031, 130, 9);

insert into games.results values( 98000031, 229, 10);
insert into games.results values( 98000031, 131, 11);
insert into games.results values( 98000031, 230, 12);
insert into games.results values( 98000031, 231, 13);
insert into games.results values( 98000031, 132, 14);

-- competition 3 - s

insert into games.results values( 98000032, 330, 1);
insert into games.results values( 98000032, 127, 2);
insert into games.results values( 98000032, 227, 3);
insert into games.results values( 98000032, 329, 4);
insert into games.results values( 98000032, 132, 5);
insert into games.results values( 98000032, 228, 6);
insert into games.results values( 98000032, 128, 7);
insert into games.results values( 98000032, 230, 8);

-- competition 3 - f

insert into games.results values( 98000033, 127, 1);
insert into games.results values( 98000033, 228, 2);
insert into games.results values( 98000033, 329, 3);
insert into games.results values( 98000033, 128, 4);
insert into games.results values( 98000033, 230, 5);
insert into games.results values( 98000033, 129, 6);
insert into games.results values( 98000033, 132, 7);

-- competition 4 - q

insert into games.results values( 98000041, 133, 1); 
insert into games.results values( 98000041, 233, 2);
insert into games.results values( 98000041, 331, 3);
insert into games.results values( 98000041, 134, 4);
insert into games.results values( 98000041, 234, 5);
insert into games.results values( 98000041, 332, 6);
insert into games.results values( 98000041, 235, 7);
insert into games.results values( 98000041, 135, 8);
insert into games.results values( 98000041, 333, 9);

insert into games.results values( 98000041, 236, 10);
insert into games.results values( 98000041, 136, 11);
insert into games.results values( 98000041, 334, 12);


-- competition 4 - s

insert into games.results values( 98000042, 235, 1); 
insert into games.results values( 98000042, 133, 2);
insert into games.results values( 98000042, 331, 3);
insert into games.results values( 98000042, 236, 4);
insert into games.results values( 98000042, 134, 5);
insert into games.results values( 98000042, 332, 6);
insert into games.results values( 98000042, 234, 7);

-- competition 4 - f

insert into games.results values( 98000043, 234, 1); 
insert into games.results values( 98000043, 331, 2);
insert into games.results values( 98000043, 133, 3);
insert into games.results values( 98000043, 235, 4);
insert into games.results values( 98000043, 332, 5);
insert into games.results values( 98000043, 134, 6);

-- competition 5 - q

insert into games.results values( 98000051, 137, 1); 
insert into games.results values( 98000051, 335, 2);
insert into games.results values( 98000051, 237, 3);
insert into games.results values( 98000051, 138, 4);
insert into games.results values( 98000051, 336, 5);
insert into games.results values( 98000051, 238, 6);
insert into games.results values( 98000051, 139, 7);
insert into games.results values( 98000051, 239, 8);
insert into games.results values( 98000051, 140, 9);

insert into games.results values( 98000051, 141, 10);

-- competition 5 - s

insert into games.results values( 98000052, 137, 1); 
insert into games.results values( 98000052, 237, 2);
insert into games.results values( 98000052, 336, 3);
insert into games.results values( 98000052, 138, 4);
insert into games.results values( 98000052, 335, 5);
insert into games.results values( 98000052, 140, 6);

-- competition 5 - f

insert into games.results values( 98000053, 137, 1); 
insert into games.results values( 98000053, 237, 2);
insert into games.results values( 98000053, 336, 3);
insert into games.results values( 98000053, 138, 4);
insert into games.results values( 98000053, 335, 5);

-- competition 6 - q

insert into games.results values( 98000061, 142, 1); 
insert into games.results values( 98000061, 240, 2);
insert into games.results values( 98000061, 143, 3);
insert into games.results values( 98000061, 337, 4);
insert into games.results values( 98000061, 144, 5);
insert into games.results values( 98000061, 145, 6);
insert into games.results values( 98000061, 146, 7);

-- competition 6 - s

insert into games.results values( 98000062, 240, 1); 
insert into games.results values( 98000062, 337, 2);
insert into games.results values( 98000062, 142, 3);
insert into games.results values( 98000062, 145, 4);
insert into games.results values( 98000062, 144, 5);
insert into games.results values( 98000062, 143, 6);

-- competition 6 - f

insert into games.results values( 98000063, 144, 1); 
insert into games.results values( 98000063, 337, 2);
insert into games.results values( 98000063, 145, 3);
insert into games.results values( 98000063, 240, 4);
insert into games.results values( 98000063, 146, 5);

-- competition 7 - q

insert into games.results values( 98000071, 241, 1); 
insert into games.results values( 98000071, 338, 2);
insert into games.results values( 98000071, 342, 3);
insert into games.results values( 98000071, 339, 4);
insert into games.results values( 98000071, 242, 5);
insert into games.results values( 98000071, 341, 6);
insert into games.results values( 98000071, 340, 7);

-- competition 7 - s

insert into games.results values( 98000072, 338, 1); 
insert into games.results values( 98000072, 339, 2);
insert into games.results values( 98000072, 241, 3);
insert into games.results values( 98000072, 340, 4);
insert into games.results values( 98000072, 341, 5);
insert into games.results values( 98000072, 242, 6);

-- competition 7 - f

insert into games.results values( 98000073, 339, 1); 
insert into games.results values( 98000073, 338, 2);
insert into games.results values( 98000073, 242, 3);
insert into games.results values( 98000073, 341, 4);
insert into games.results values( 98000073, 340, 5);

-- competition 8 - q

insert into games.results values( 98000081, 147, 1); 
insert into games.results values( 98000081, 345, 2);
insert into games.results values( 98000081, 347, 3);
insert into games.results values( 98000081, 344, 4);
insert into games.results values( 98000081, 346, 5);
insert into games.results values( 98000081, 348, 6);
insert into games.results values( 98000081, 343, 7);

-- competition 8 - s

insert into games.results values( 98000082, 343, 1); 
insert into games.results values( 98000082, 147, 2);
insert into games.results values( 98000082, 344, 3);
insert into games.results values( 98000082, 345, 4);
insert into games.results values( 98000082, 346, 5);
insert into games.results values( 98000082, 347, 6);

-- competition 8 - f

insert into games.results values( 98000083, 343, 1); 
insert into games.results values( 98000083, 344, 2);
insert into games.results values( 98000083, 147, 3);
insert into games.results values( 98000083, 345, 4);
insert into games.results values( 98000083, 346, 5);

-- competition 9 - q

insert into games.results values( 98000091, 148, 1); 
insert into games.results values( 98000091, 243, 2);
insert into games.results values( 98000091, 244, 3);
insert into games.results values( 98000091, 149, 4);
insert into games.results values( 98000091, 245, 5);
insert into games.results values( 98000091, 246, 6);
insert into games.results values( 98000091, 247, 7);

-- competition 9 - s

insert into games.results values( 98000092, 243, 1); 
insert into games.results values( 98000092, 244, 2);
insert into games.results values( 98000092, 148, 3);
insert into games.results values( 98000092, 246, 4);
insert into games.results values( 98000092, 247, 5);
insert into games.results values( 98000092, 149, 6);

-- competition 9 - f

insert into games.results values( 98000093, 243, 1); 
insert into games.results values( 98000093, 148, 2);
insert into games.results values( 98000093, 244, 3);
insert into games.results values( 98000093, 245, 4);
insert into games.results values( 98000093, 246, 5);
-- -----------------------------------------

-- for olympic 2002

insert into games.results values( 2000011, 101, 1); 
insert into games.results values( 2000011, 201, 2);
insert into games.results values( 2000011, 102, 3);
insert into games.results values( 2000011, 202, 4);
insert into games.results values( 2000011, 103, 5);
insert into games.results values( 2000011, 203, 6); 
insert into games.results values( 2000011, 104, 7);
insert into games.results values( 2000011, 204, 8);
insert into games.results values( 2000011, 105, 9);

insert into games.results values( 2000011, 205, 10); 
insert into games.results values( 2000011, 106, 11);
insert into games.results values( 2000011, 206, 12);
insert into games.results values( 2000011, 107, 13);
insert into games.results values( 2000011, 207, 14);
insert into games.results values( 2000011, 108, 15); 
insert into games.results values( 2000011, 301, 16);
insert into games.results values( 2000011, 109, 17);
insert into games.results values( 2000011, 302, 18);
insert into games.results values( 2000011, 110, 19);

insert into games.results values( 2000011, 208, 20); 
insert into games.results values( 2000011, 111, 21);
insert into games.results values( 2000011, 303, 22);
insert into games.results values( 2000011, 112, 23);
insert into games.results values( 2000011, 304, 24);
insert into games.results values( 2000011, 113, 25); 
insert into games.results values( 2000011, 305, 26);
insert into games.results values( 2000011, 114, 27);
insert into games.results values( 2000011, 209, 28);
insert into games.results values( 2000011, 306, 29);

insert into games.results values( 2000011, 210, 30); 
insert into games.results values( 2000011, 307, 31);
insert into games.results values( 2000011, 211, 32);
insert into games.results values( 2000011, 308, 33);
insert into games.results values( 2000011, 212, 34);
insert into games.results values( 2000011, 309, 35); 
insert into games.results values( 2000011, 213, 36);
insert into games.results values( 2000011, 310, 37);
insert into games.results values( 2000011, 311, 38);
insert into games.results values( 2000011, 312, 39);

insert into games.results values( 2000011, 214, 40); 
insert into games.results values( 2000011, 313, 41);
insert into games.results values( 2000011, 314, 42);
insert into games.results values( 2000011, 315, 43);
insert into games.results values( 2000011, 316, 44);
insert into games.results values( 2000011, 150, 45);
insert into games.results values( 2000011, 248, 46);
insert into games.results values( 2000011, 151, 47);
insert into games.results values( 2000011, 249, 48);
insert into games.results values( 2000011, 152, 49);

insert into games.results values( 2000011, 250, 50);
insert into games.results values( 2000011, 153, 51);
insert into games.results values( 2000011, 251, 52);
insert into games.results values( 2000011, 154, 53);
insert into games.results values( 2000011, 252, 54);
insert into games.results values( 2000011, 155, 55);
insert into games.results values( 2000011, 253, 56);
insert into games.results values( 2000011, 156, 57);
insert into games.results values( 2000011, 254, 58);
insert into games.results values( 2000011, 157, 59);

insert into games.results values( 2000011, 255, 60);

insert into games.results values( 2000012, 301, 1); 
insert into games.results values( 2000012, 201, 2);
insert into games.results values( 2000012, 101, 3);
insert into games.results values( 2000012, 302, 4);
insert into games.results values( 2000012, 202, 5);
insert into games.results values( 2000012, 303, 6);
insert into games.results values( 2000012, 102, 7);
insert into games.results values( 2000012, 305, 8);
insert into games.results values( 2000012, 203, 9);

insert into games.results values( 2000012, 103, 10); 
insert into games.results values( 2000012, 315, 11);
insert into games.results values( 2000012, 204, 12);
insert into games.results values( 2000012, 104, 13);
insert into games.results values( 2000012, 306, 14);
insert into games.results values( 2000012, 205, 15);
insert into games.results values( 2000012, 105, 16);
insert into games.results values( 2000012, 307, 17);
insert into games.results values( 2000012, 206, 18);
insert into games.results values( 2000012, 308, 19);

insert into games.results values( 2000012, 207, 20); 
insert into games.results values( 2000012, 309, 21);
insert into games.results values( 2000012, 106, 22);
insert into games.results values( 2000012, 208, 23);
insert into games.results values( 2000012, 107, 24);
insert into games.results values( 2000012, 209, 25);
insert into games.results values( 2000012, 108, 26);
insert into games.results values( 2000012, 109, 27);
insert into games.results values( 2000012, 110, 28);

insert into games.results values( 2000013, 201, 1); 
insert into games.results values( 2000013, 101, 2);
insert into games.results values( 2000013, 301, 3);
insert into games.results values( 2000013, 202, 4);
insert into games.results values( 2000013, 102, 5);
insert into games.results values( 2000013, 302, 6);
insert into games.results values( 2000013, 203, 7);
insert into games.results values( 2000013, 303, 8);
insert into games.results values( 2000013, 103, 9);

insert into games.results values( 2000013, 304, 10);
insert into games.results values( 2000013, 204, 11);
insert into games.results values( 2000013, 104, 12);
insert into games.results values( 2000013, 305, 13);
insert into games.results values( 2000013, 306, 14);


insert into games.results values( 2000021, 215, 1); 
insert into games.results values( 2000021, 328, 2);
insert into games.results values( 2000021, 115, 3);
insert into games.results values( 2000021, 317, 4);
insert into games.results values( 2000021, 216, 5);
insert into games.results values( 2000021, 116, 6);
insert into games.results values( 2000021, 318, 7);
insert into games.results values( 2000021, 217, 8);
insert into games.results values( 2000021, 117, 9);

insert into games.results values( 2000021, 218, 10);
insert into games.results values( 2000021, 319, 11);
insert into games.results values( 2000021, 118, 12);
insert into games.results values( 2000021, 320, 13);
insert into games.results values( 2000021, 219, 14);
insert into games.results values( 2000021, 321, 15);
insert into games.results values( 2000021, 119, 16);
insert into games.results values( 2000021, 220, 17);
insert into games.results values( 2000021, 322, 18);
insert into games.results values( 2000021, 120, 19);

insert into games.results values( 2000021, 221, 20);
insert into games.results values( 2000021, 323, 21);
insert into games.results values( 2000021, 121, 22);
insert into games.results values( 2000021, 222, 23);
insert into games.results values( 2000021, 122, 24);
insert into games.results values( 2000021, 223, 25);
insert into games.results values( 2000021, 123, 26);
insert into games.results values( 2000021, 324, 27);
insert into games.results values( 2000021, 124, 28);
insert into games.results values( 2000021, 224, 29);

insert into games.results values( 2000021, 225, 30);
insert into games.results values( 2000021, 125, 31);
insert into games.results values( 2000021, 226, 32);
insert into games.results values( 2000021, 126, 33);
insert into games.results values( 2000021, 325, 34);
insert into games.results values( 2000021, 326, 35);
insert into games.results values( 2000021, 327, 36);

insert into games.results values( 2000022, 115, 1); 
insert into games.results values( 2000022, 215, 2);
insert into games.results values( 2000022, 328, 3);
insert into games.results values( 2000022, 116, 4);
insert into games.results values( 2000022, 216, 5);
insert into games.results values( 2000022, 117, 6);
insert into games.results values( 2000022, 317, 7);
insert into games.results values( 2000022, 217, 8);
insert into games.results values( 2000022, 118, 9);

insert into games.results values( 2000023, 117, 1); 
insert into games.results values( 2000023, 216, 2);
insert into games.results values( 2000023, 328, 3);
insert into games.results values( 2000023, 115, 4);
insert into games.results values( 2000023, 317, 5);
insert into games.results values( 2000023, 217, 6);
insert into games.results values( 2000023, 116, 7);


insert into games.results values( 2000031, 127, 1); 
insert into games.results values( 2000031, 329, 2);
insert into games.results values( 2000031, 227, 3);
insert into games.results values( 2000031, 128, 4);
insert into games.results values( 2000031, 330, 5);
insert into games.results values( 2000031, 228, 6);
insert into games.results values( 2000031, 129, 7);
insert into games.results values( 2000031, 232, 8);
insert into games.results values( 2000031, 130, 9);

insert into games.results values( 2000031, 229, 10);
insert into games.results values( 2000031, 131, 11);
insert into games.results values( 2000031, 230, 12);
insert into games.results values( 2000031, 231, 13);
insert into games.results values( 2000031, 132, 14);

insert into games.results values( 2000032, 330, 1);
insert into games.results values( 2000032, 127, 2);
insert into games.results values( 2000032, 227, 3);
insert into games.results values( 2000032, 329, 4);
insert into games.results values( 2000032, 132, 5);
insert into games.results values( 2000032, 228, 6);
insert into games.results values( 2000032, 128, 7);
insert into games.results values( 2000032, 230, 8);

insert into games.results values( 2000033, 127, 1);
insert into games.results values( 2000033, 228, 2);
insert into games.results values( 2000033, 329, 3);
insert into games.results values( 2000033, 128, 4);
insert into games.results values( 2000033, 230, 5);
insert into games.results values( 2000033, 129, 6);
insert into games.results values( 2000033, 132, 7);

insert into games.results values( 2000041, 133, 1); 
insert into games.results values( 2000041, 233, 2);
insert into games.results values( 2000041, 331, 3);
insert into games.results values( 2000041, 134, 4);
insert into games.results values( 2000041, 234, 5);
insert into games.results values( 2000041, 332, 6);
insert into games.results values( 2000041, 235, 7);
insert into games.results values( 2000041, 135, 8);
insert into games.results values( 2000041, 333, 9);

insert into games.results values( 2000041, 236, 10);
insert into games.results values( 2000041, 136, 11);
insert into games.results values( 2000041, 334, 12);

insert into games.results values( 2000042, 235, 1); 
insert into games.results values( 2000042, 133, 2);
insert into games.results values( 2000042, 331, 3);
insert into games.results values( 2000042, 236, 4);
insert into games.results values( 2000042, 134, 5);
insert into games.results values( 2000042, 332, 6);
insert into games.results values( 2000042, 234, 7);

insert into games.results values( 2000043, 234, 1); 
insert into games.results values( 2000043, 331, 2);
insert into games.results values( 2000043, 133, 3);
insert into games.results values( 2000043, 235, 4);
insert into games.results values( 2000043, 332, 5);
insert into games.results values( 2000043, 134, 6);

insert into games.results values( 2000051, 137, 1); 
insert into games.results values( 2000051, 335, 2);
insert into games.results values( 2000051, 237, 3);
insert into games.results values( 2000051, 138, 4);
insert into games.results values( 2000051, 336, 5);
insert into games.results values( 2000051, 238, 6);
insert into games.results values( 2000051, 139, 7);
insert into games.results values( 2000051, 239, 8);
insert into games.results values( 2000051, 140, 9);

insert into games.results values( 2000051, 141, 10);

insert into games.results values( 2000052, 137, 1); 
insert into games.results values( 2000052, 237, 2);
insert into games.results values( 2000052, 336, 3);
insert into games.results values( 2000052, 138, 4);
insert into games.results values( 2000052, 335, 5);
insert into games.results values( 2000052, 140, 6);

insert into games.results values( 2000053, 137, 1); 
insert into games.results values( 2000053, 237, 2);
insert into games.results values( 2000053, 336, 3);
insert into games.results values( 2000053, 138, 4);
insert into games.results values( 2000053, 335, 5);

insert into games.results values( 2000061, 142, 1); 
insert into games.results values( 2000061, 240, 2);
insert into games.results values( 2000061, 143, 3);
insert into games.results values( 2000061, 337, 4);
insert into games.results values( 2000061, 144, 5);
insert into games.results values( 2000061, 145, 6);
insert into games.results values( 2000061, 146, 7);

insert into games.results values( 2000062, 240, 1); 
insert into games.results values( 2000062, 337, 2);
insert into games.results values( 2000062, 142, 3);
insert into games.results values( 2000062, 145, 4);
insert into games.results values( 2000062, 144, 5);
insert into games.results values( 2000062, 143, 6);

insert into games.results values( 2000063, 144, 1); 
insert into games.results values( 2000063, 337, 2);
insert into games.results values( 2000063, 145, 3);
insert into games.results values( 2000063, 240, 4);
insert into games.results values( 2000063, 146, 5);

insert into games.results values( 2000071, 241, 1); 
insert into games.results values( 2000071, 338, 2);
insert into games.results values( 2000071, 342, 3);
insert into games.results values( 2000071, 339, 4);
insert into games.results values( 2000071, 242, 5);
insert into games.results values( 2000071, 341, 6);
insert into games.results values( 2000071, 340, 7);

insert into games.results values( 2000072, 338, 1); 
insert into games.results values( 2000072, 339, 2);
insert into games.results values( 2000072, 241, 3);
insert into games.results values( 2000072, 340, 4);
insert into games.results values( 2000072, 341, 5);
insert into games.results values( 2000072, 242, 6);

insert into games.results values( 2000073, 339, 1); 
insert into games.results values( 2000073, 338, 2);
insert into games.results values( 2000073, 242, 3);
insert into games.results values( 2000073, 341, 4);
insert into games.results values( 2000073, 340, 5);

insert into games.results values( 2000081, 147, 1); 
insert into games.results values( 2000081, 345, 2);
insert into games.results values( 2000081, 347, 3);
insert into games.results values( 2000081, 344, 4);
insert into games.results values( 2000081, 346, 5);
insert into games.results values( 2000081, 348, 6);
insert into games.results values( 2000081, 343, 7);

insert into games.results values( 2000082, 343, 1); 
insert into games.results values( 2000082, 147, 2);
insert into games.results values( 2000082, 344, 3);
insert into games.results values( 2000082, 345, 4);
insert into games.results values( 2000082, 346, 5);
insert into games.results values( 2000082, 347, 6);

insert into games.results values( 2000083, 343, 1); 
insert into games.results values( 2000083, 344, 2);
insert into games.results values( 2000083, 147, 3);
insert into games.results values( 2000083, 345, 4);
insert into games.results values( 2000083, 346, 5);

insert into games.results values( 2000091, 148, 1); 
insert into games.results values( 2000091, 243, 2);
insert into games.results values( 2000091, 244, 3);
insert into games.results values( 2000091, 149, 4);
insert into games.results values( 2000091, 245, 5);
insert into games.results values( 2000091, 246, 6);
insert into games.results values( 2000091, 247, 7);

insert into games.results values( 2000092, 243, 1); 
insert into games.results values( 2000092, 244, 2);
insert into games.results values( 2000092, 148, 3);
insert into games.results values( 2000092, 246, 4);
insert into games.results values( 2000092, 247, 5);
insert into games.results values( 2000092, 149, 6);

insert into games.results values( 2000093, 243, 1); 
insert into games.results values( 2000093, 148, 2);
insert into games.results values( 2000093, 244, 3);
insert into games.results values( 2000093, 245, 4);
insert into games.results values( 2000093, 246, 5);

-- -----------------------------------------

-- for olympic 2006

insert into games.results values( 6000011, 101, 1); 
insert into games.results values( 6000011, 201, 2);
insert into games.results values( 6000011, 102, 3);
insert into games.results values( 6000011, 202, 4);
insert into games.results values( 6000011, 103, 5);
insert into games.results values( 6000011, 203, 6); 
insert into games.results values( 6000011, 104, 7);
insert into games.results values( 6000011, 204, 8);
insert into games.results values( 6000011, 105, 9);

insert into games.results values( 6000011, 205, 10); 
insert into games.results values( 6000011, 106, 11);
insert into games.results values( 6000011, 206, 12);
insert into games.results values( 6000011, 107, 13);
insert into games.results values( 6000011, 207, 14);
insert into games.results values( 6000011, 108, 15); 
insert into games.results values( 6000011, 301, 16);
insert into games.results values( 6000011, 109, 17);
insert into games.results values( 6000011, 302, 18);
insert into games.results values( 6000011, 110, 19);

insert into games.results values( 6000011, 208, 20); 
insert into games.results values( 6000011, 111, 21);
insert into games.results values( 6000011, 303, 22);
insert into games.results values( 6000011, 112, 23);
insert into games.results values( 6000011, 304, 24);
insert into games.results values( 6000011, 113, 25); 
insert into games.results values( 6000011, 305, 26);
insert into games.results values( 6000011, 114, 27);
insert into games.results values( 6000011, 209, 28);
insert into games.results values( 6000011, 306, 29);

insert into games.results values( 6000011, 210, 30); 
insert into games.results values( 6000011, 307, 31);
insert into games.results values( 6000011, 211, 32);
insert into games.results values( 6000011, 308, 33);
insert into games.results values( 6000011, 212, 34);
insert into games.results values( 6000011, 309, 35); 
insert into games.results values( 6000011, 213, 36);
insert into games.results values( 6000011, 310, 37);
insert into games.results values( 6000011, 311, 38);
insert into games.results values( 6000011, 312, 39);

insert into games.results values( 6000011, 214, 40); 
insert into games.results values( 6000011, 313, 41);
insert into games.results values( 6000011, 314, 42);
insert into games.results values( 6000011, 315, 43);
insert into games.results values( 6000011, 316, 44);
insert into games.results values( 6000011, 150, 45);
insert into games.results values( 6000011, 248, 46);
insert into games.results values( 6000011, 151, 47);
insert into games.results values( 6000011, 249, 48);
insert into games.results values( 6000011, 152, 49);

insert into games.results values( 6000011, 250, 50);
insert into games.results values( 6000011, 153, 51);
insert into games.results values( 6000011, 251, 52);
insert into games.results values( 6000011, 154, 53);
insert into games.results values( 6000011, 252, 54);
insert into games.results values( 6000011, 155, 55);
insert into games.results values( 6000011, 253, 56);
insert into games.results values( 6000011, 156, 57);
insert into games.results values( 6000011, 254, 58);
insert into games.results values( 6000011, 157, 59);

insert into games.results values( 6000011, 255, 60);

insert into games.results values( 6000012, 301, 1); 
insert into games.results values( 6000012, 201, 2);
insert into games.results values( 6000012, 101, 3);
insert into games.results values( 6000012, 302, 4);
insert into games.results values( 6000012, 202, 5);
insert into games.results values( 6000012, 303, 6);
insert into games.results values( 6000012, 102, 7);
insert into games.results values( 6000012, 305, 8);
insert into games.results values( 6000012, 203, 9);

insert into games.results values( 6000012, 103, 10); 
insert into games.results values( 6000012, 315, 11);
insert into games.results values( 6000012, 204, 12);
insert into games.results values( 6000012, 104, 13);
insert into games.results values( 6000012, 306, 14);
insert into games.results values( 6000012, 205, 15);
insert into games.results values( 6000012, 105, 16);
insert into games.results values( 6000012, 307, 17);
insert into games.results values( 6000012, 206, 18);
insert into games.results values( 6000012, 308, 19);

insert into games.results values( 6000012, 207, 20); 
insert into games.results values( 6000012, 309, 21);
insert into games.results values( 6000012, 106, 22);
insert into games.results values( 6000012, 208, 23);
insert into games.results values( 6000012, 107, 24);
insert into games.results values( 6000012, 209, 25);
insert into games.results values( 6000012, 108, 26);
insert into games.results values( 6000012, 109, 27);
insert into games.results values( 6000012, 110, 28);

insert into games.results values( 6000013, 201, 1); 
insert into games.results values( 6000013, 101, 2);
insert into games.results values( 6000013, 301, 3);
insert into games.results values( 6000013, 202, 4);
insert into games.results values( 6000013, 102, 5);
insert into games.results values( 6000013, 302, 6);
insert into games.results values( 6000013, 203, 7);
insert into games.results values( 6000013, 303, 8);
insert into games.results values( 6000013, 103, 9);

insert into games.results values( 6000013, 304, 10);
insert into games.results values( 6000013, 204, 11);
insert into games.results values( 6000013, 104, 12);
insert into games.results values( 6000013, 305, 13);
insert into games.results values( 6000013, 306, 14);


insert into games.results values( 6000021, 215, 1); 
insert into games.results values( 6000021, 328, 2);
insert into games.results values( 6000021, 115, 3);
insert into games.results values( 6000021, 317, 4);
insert into games.results values( 6000021, 216, 5);
insert into games.results values( 6000021, 116, 6);
insert into games.results values( 6000021, 318, 7);
insert into games.results values( 6000021, 217, 8);
insert into games.results values( 6000021, 117, 9);

insert into games.results values( 6000021, 218, 10);
insert into games.results values( 6000021, 319, 11);
insert into games.results values( 6000021, 118, 12);
insert into games.results values( 6000021, 320, 13);
insert into games.results values( 6000021, 219, 14);
insert into games.results values( 6000021, 321, 15);
insert into games.results values( 6000021, 119, 16);
insert into games.results values( 6000021, 220, 17);
insert into games.results values( 6000021, 322, 18);
insert into games.results values( 6000021, 120, 19);

insert into games.results values( 6000021, 221, 20);
insert into games.results values( 6000021, 323, 21);
insert into games.results values( 6000021, 121, 22);
insert into games.results values( 6000021, 222, 23);
insert into games.results values( 6000021, 122, 24);
insert into games.results values( 6000021, 223, 25);
insert into games.results values( 6000021, 123, 26);
insert into games.results values( 6000021, 324, 27);
insert into games.results values( 6000021, 124, 28);
insert into games.results values( 6000021, 224, 29);

insert into games.results values( 6000021, 225, 30);
insert into games.results values( 6000021, 125, 31);
insert into games.results values( 6000021, 226, 32);
insert into games.results values( 6000021, 126, 33);
insert into games.results values( 6000021, 325, 34);
insert into games.results values( 6000021, 326, 35);
insert into games.results values( 6000021, 327, 36);

insert into games.results values( 6000022, 115, 1); 
insert into games.results values( 6000022, 215, 2);
insert into games.results values( 6000022, 328, 3);
insert into games.results values( 6000022, 116, 4);
insert into games.results values( 6000022, 216, 5);
insert into games.results values( 6000022, 117, 6);
insert into games.results values( 6000022, 317, 7);
insert into games.results values( 6000022, 217, 8);
insert into games.results values( 6000022, 118, 9);

insert into games.results values( 6000023, 117, 1); 
insert into games.results values( 6000023, 216, 2);
insert into games.results values( 6000023, 328, 3);
insert into games.results values( 6000023, 115, 4);
insert into games.results values( 6000023, 317, 5);
insert into games.results values( 6000023, 217, 6);
insert into games.results values( 6000023, 116, 7);


insert into games.results values( 6000031, 127, 1); 
insert into games.results values( 6000031, 329, 2);
insert into games.results values( 6000031, 227, 3);
insert into games.results values( 6000031, 128, 4);
insert into games.results values( 6000031, 330, 5);
insert into games.results values( 6000031, 228, 6);
insert into games.results values( 6000031, 129, 7);
insert into games.results values( 6000031, 232, 8);
insert into games.results values( 6000031, 130, 9);

insert into games.results values( 6000031, 229, 10);
insert into games.results values( 6000031, 131, 11);
insert into games.results values( 6000031, 230, 12);
insert into games.results values( 6000031, 231, 13);
insert into games.results values( 6000031, 132, 14);

insert into games.results values( 6000032, 330, 1);
insert into games.results values( 6000032, 127, 2);
insert into games.results values( 6000032, 227, 3);
insert into games.results values( 6000032, 329, 4);
insert into games.results values( 6000032, 132, 5);
insert into games.results values( 6000032, 228, 6);
insert into games.results values( 6000032, 128, 7);
insert into games.results values( 6000032, 230, 8);

insert into games.results values( 6000033, 127, 1);
insert into games.results values( 6000033, 228, 2);
insert into games.results values( 6000033, 329, 3);
insert into games.results values( 6000033, 128, 4);
insert into games.results values( 6000033, 230, 5);
insert into games.results values( 6000033, 129, 6);
insert into games.results values( 6000033, 132, 7);

insert into games.results values( 6000041, 133, 1); 
insert into games.results values( 6000041, 233, 2);
insert into games.results values( 6000041, 331, 3);
insert into games.results values( 6000041, 134, 4);
insert into games.results values( 6000041, 234, 5);
insert into games.results values( 6000041, 332, 6);
insert into games.results values( 6000041, 235, 7);
insert into games.results values( 6000041, 135, 8);
insert into games.results values( 6000041, 333, 9);

insert into games.results values( 6000041, 236, 10);
insert into games.results values( 6000041, 136, 11);
insert into games.results values( 6000041, 334, 12);

insert into games.results values( 6000042, 235, 1); 
insert into games.results values( 6000042, 133, 2);
insert into games.results values( 6000042, 331, 3);
insert into games.results values( 6000042, 236, 4);
insert into games.results values( 6000042, 134, 5);
insert into games.results values( 6000042, 332, 6);
insert into games.results values( 6000042, 234, 7);

insert into games.results values( 6000043, 234, 1);
insert into games.results values( 6000043, 331, 2);
insert into games.results values( 6000043, 133, 3);
insert into games.results values( 6000043, 235, 4);
insert into games.results values( 6000043, 332, 5);
insert into games.results values( 6000043, 134, 6);

insert into games.results values( 6000051, 137, 1);
insert into games.results values( 6000051, 335, 2);
insert into games.results values( 6000051, 237, 3);
insert into games.results values( 6000051, 138, 4);
insert into games.results values( 6000051, 336, 5);
insert into games.results values( 6000051, 238, 6);
insert into games.results values( 6000051, 139, 7);
insert into games.results values( 6000051, 239, 8);
insert into games.results values( 6000051, 140, 9);

insert into games.results values( 6000051, 141, 10);

insert into games.results values( 6000052, 137, 1); 
insert into games.results values( 6000052, 237, 2);
insert into games.results values( 6000052, 336, 3);
insert into games.results values( 6000052, 138, 4);
insert into games.results values( 6000052, 335, 5);
insert into games.results values( 6000052, 140, 6);

insert into games.results values( 6000053, 137, 1);
insert into games.results values( 6000053, 237, 2);
insert into games.results values( 6000053, 336, 3);
insert into games.results values( 6000053, 138, 4);
insert into games.results values( 6000053, 335, 5);

insert into games.results values( 6000061, 142, 1);
insert into games.results values( 6000061, 240, 2);
insert into games.results values( 6000061, 143, 3);
insert into games.results values( 6000061, 337, 4);
insert into games.results values( 6000061, 144, 5);
insert into games.results values( 6000061, 145, 6);
insert into games.results values( 6000061, 146, 7);

insert into games.results values( 6000062, 240, 1);
insert into games.results values( 6000062, 337, 2);
insert into games.results values( 6000062, 142, 3);
insert into games.results values( 6000062, 145, 4);
insert into games.results values( 6000062, 144, 5);
insert into games.results values( 6000062, 143, 6);

insert into games.results values( 6000063, 144, 1); 
insert into games.results values( 6000063, 337, 2);
insert into games.results values( 6000063, 145, 3);
insert into games.results values( 6000063, 240, 4);
insert into games.results values( 6000063, 146, 5);

insert into games.results values( 6000071, 241, 1);
insert into games.results values( 6000071, 338, 2);
insert into games.results values( 6000071, 342, 3);
insert into games.results values( 6000071, 339, 4);
insert into games.results values( 6000071, 242, 5);
insert into games.results values( 6000071, 341, 6);
insert into games.results values( 6000071, 340, 7);

insert into games.results values( 6000072, 338, 1);
insert into games.results values( 6000072, 339, 2);
insert into games.results values( 6000072, 241, 3);
insert into games.results values( 6000072, 340, 4);
insert into games.results values( 6000072, 341, 5);
insert into games.results values( 6000072, 242, 6);

insert into games.results values( 6000073, 339, 1); 
insert into games.results values( 6000073, 338, 2);
insert into games.results values( 6000073, 242, 3);
insert into games.results values( 6000073, 341, 4);
insert into games.results values( 6000073, 340, 5);

insert into games.results values( 6000081, 147, 1); 
insert into games.results values( 6000081, 345, 2);
insert into games.results values( 6000081, 347, 3);
insert into games.results values( 6000081, 344, 4);
insert into games.results values( 6000081, 346, 5);
insert into games.results values( 6000081, 348, 6);
insert into games.results values( 6000081, 343, 7);

insert into games.results values( 6000082, 343, 1); 
insert into games.results values( 6000082, 147, 2);
insert into games.results values( 6000082, 344, 3);
insert into games.results values( 6000082, 345, 4);
insert into games.results values( 6000082, 346, 5);
insert into games.results values( 6000082, 347, 6);

insert into games.results values( 6000083, 343, 1); 
insert into games.results values( 6000083, 344, 2);
insert into games.results values( 6000083, 147, 3);
insert into games.results values( 6000083, 345, 4);
insert into games.results values( 6000083, 346, 5);

insert into games.results values( 6000091, 148, 1); 
insert into games.results values( 6000091, 243, 2);
insert into games.results values( 6000091, 244, 3);
insert into games.results values( 6000091, 149, 4);
insert into games.results values( 6000091, 245, 5);
insert into games.results values( 6000091, 246, 6);
insert into games.results values( 6000091, 247, 7);

insert into games.results values( 6000092, 243, 1); 
insert into games.results values( 6000092, 244, 2);
insert into games.results values( 6000092, 148, 3);
insert into games.results values( 6000092, 246, 4);
insert into games.results values( 6000092, 247, 5);
insert into games.results values( 6000092, 149, 6);

insert into games.results values( 6000093, 243, 1); 
insert into games.results values( 6000093, 148, 2);
insert into games.results values( 6000093, 244, 3);
insert into games.results values( 6000093, 245, 4);
insert into games.results values( 6000093, 246, 5);


-- -----------------------------------------




