create table league (pos int, team VARCHAR(30), won int, drawn int, lost int, goalsfor int, goalsagainst int, goaldiff int, points int, st int, et int);

create table fa_cup (team VARCHAR(30), st int, et int);

create table league_cup (team VARCHAR(30), st int, et int);

create table time (time int, st int, et int);

insert into time values(1992,0,0);
insert into time values(1993,1,1);
insert into time values(1994,2,2);
insert into time values(1995,3,3);
insert into time values(1996,4,4);
insert into time values(1997,5,5);
insert into time values(1998,6,6);
insert into time values(1999,7,7);
insert into time values(2000,8,8);
insert into time values(2001,9,9);
insert into time values(2002,10,10);
insert into time values(2003,11,11);
insert into time values(2004,12,12);

insert into fa_cup values('Arsenal', 8, 9);
insert into fa_cup values('Liverpool', 7, 7);
insert into fa_cup values('Chelsea', 6, 6);
insert into fa_cup values('Man Utd', 5, 5);
insert into fa_cup values('Arsenal', 4, 4);
insert into fa_cup values('Chelsea', 3, 3);
insert into fa_cup values('Man Utd', 2, 2);
insert into fa_cup values('Everton', 1, 1);
insert into fa_cup values('Man Utd', 0, 0);

insert into league_cup values('Liverpool', 9, 9);
insert into league_cup values('Blackburn', 8, 8);
insert into league_cup values('Liverpool', 7, 7);
insert into league_cup values('Leicester City', 6, 6);
insert into league_cup values('Tottenham', 5, 5);
insert into league_cup values('Chelsea', 4, 4);
insert into league_cup values('Leicester City', 3, 3);
insert into league_cup values('Aston Villa', 2, 2);
insert into league_cup values('Liverpool', 1, 1);
insert into league_cup values('Aston Villa', 0, 0);

insert into league values(1, 'Man Utd', 25, 8, 5, 74, 34, 40, 83, 9, 9);
insert into league values(2, 'Arsenal', 23, 9, 6, 85, 42, 43, 78, 9, 9);
insert into league values(3, 'Newcastle Utd', 21, 6, 11, 63, 48, 15, 69, 9, 9);
insert into league values(4, 'Chelsea', 19, 10, 9, 68, 38, 30, 67, 9, 9);
insert into league values(5, 'Liverpool', 18, 10, 10, 61, 41, 20, 64, 9, 9);
insert into league values(6, 'Blackburn', 16, 12, 10, 52, 43, 9, 60, 9, 9);
insert into league values(7, 'Everton', 17, 8, 13, 48, 49, -1, 59, 9, 9);
insert into league values(8, 'Southampton', 13, 13, 12, 43, 46, -3, 52, 9, 9);
insert into league values(9, 'Man City', 15, 6, 17, 47, 54, -7, 51, 9, 9);
insert into league values(10, 'Tottenham', 14, 8, 16, 51, 62, -11, 50, 9, 9);
insert into league values(11, 'Middlesbrough', 13, 10, 15, 48, 44, 4, 49, 9, 9);
insert into league values(12, 'Charlton', 14, 7, 17, 45, 56, -11, 49, 9, 9);
insert into league values(13, 'Birmingham City', 13, 9, 16, 41, 49, -8, 48, 9, 9);
insert into league values(14, 'Fulham', 13, 9, 16, 41, 50, -9, 48, 9, 9);
insert into league values(15, 'Leeds Utd', 14, 5, 19, 58, 57, 1, 47, 9, 9);
insert into league values(16, 'Aston Villa', 12, 9, 17, 42, 47, -5, 45, 9, 9);
insert into league values(17, 'Bolton', 10, 14, 14, 41, 51, -10, 44, 9, 9);
insert into league values(18, 'WestHam Utd', 10, 12, 16, 42, 59, -17, 42, 9, 9);
insert into league values(19, 'WestBrom', 6, 8, 24, 29, 65, -36, 26, 9, 9);
insert into league values(20, 'Sunderland', 4, 7, 27, 21, 65, -44, 19, 9, 9);
insert into league values(1, 'Arsenal', 26, 9, 3, 79, 36, 43, 87, 8, 8);
insert into league values(2, 'Liverpool', 24, 8, 6, 67, 30, 37, 80, 8, 8);
insert into league values(3, 'Man Utd', 24, 5, 9, 87, 45, 42, 77, 8, 8);
insert into league values(4, 'Newcastle Utd', 21, 8, 9, 74, 52, 22, 71, 8, 8);
insert into league values(5, 'Leeds Utd', 18, 12, 8, 53, 37, 16, 66, 8, 8);
insert into league values(6, 'Chelsea', 17, 13, 8, 66, 38, 28, 64, 8, 8);
insert into league values(7, 'WestHam Utd', 15, 8, 15, 48, 57, -9, 53, 8, 8);
insert into league values(8, 'Aston Villa', 12, 14, 12, 46, 47, -1, 50, 8, 8);
insert into league values(9, 'Tottenham', 14, 8, 16, 49, 53, -4, 50, 8, 8);
insert into league values(10, 'Blackburn', 12, 10, 16, 55, 51, 4, 46, 8, 8);
insert into league values(11, 'Southampton', 12, 9, 17, 46, 54, -8, 45, 8, 8);
insert into league values(12, 'Middlesbrough', 12, 9, 17, 35, 47, -12, 45, 8, 8);
insert into league values(13, 'Fulham', 10, 14, 14, 36, 44, -8, 44, 8, 8);
insert into league values(14, 'Charlton', 10, 14, 14, 38, 49, -11, 44, 8, 8);
insert into league values(15, 'Everton', 11, 10, 17, 45, 57, -12, 43, 8, 8);
insert into league values(16, 'Bolton', 9, 13, 16, 44, 62, -18, 40, 8, 8);
insert into league values(17, 'Sunderland', 10, 10, 18, 21, 51, -22, 40, 8, 8);
insert into league values(18, 'Ipswich Town', 9, 9, 20, 41, 64, -23, 36, 8, 8);
insert into league values(19, 'Derby County', 8, 6, 24, 33, 63, -30, 30, 8, 8);
insert into league values(20, 'Leicester City', 5, 13, 20, 30, 64, -34, 28, 8, 8);
insert into league values(1, 'Man Utd', 24, 8, 6, 79, 31, 48, 80, 7, 7);
insert into league values(2, 'Arsenal', 20, 10, 8, 63, 38, 25, 70, 7, 7);
insert into league values(3, 'Liverpool', 20, 9, 9, 71, 39, 32, 69, 7, 7);
insert into league values(4, 'Leeds Utd', 20, 8, 10, 64, 43, 21, 68, 7, 7);
insert into league values(5, 'Ipswich Town', 20, 6, 12, 57, 42, 15, 66, 7, 7);
insert into league values(6, 'Chelsea', 17, 10, 11, 68, 45, 23, 61, 7, 7);
insert into league values(7, 'Sunderland', 15, 12, 11, 46, 41, 5, 57, 7, 7);
insert into league values(8, 'Aston Villa', 13, 15, 10, 46, 43, 3, 54, 7, 7);
insert into league values(9, 'Charlton', 14, 10, 14, 50, 57, -7, 52, 7, 7);
insert into league values(10, 'Southampton', 14, 10, 14, 40, 48, -8, 52, 7, 7);
insert into league values(11, 'Newcastle Utd', 14, 9, 15, 44, 50, -6, 51, 7, 7);
insert into league values(12, 'Tottenham', 13, 10, 15, 47, 54, -7, 49, 7, 7);
insert into league values(13, 'Leicester City', 14, 6, 18, 39, 51, -12, 48, 7, 7);
insert into league values(14, 'Middlesbrough', 9, 15, 14, 44, 44, 0, 42, 7, 7);
insert into league values(15, 'WestHam Utd', 10, 12, 16, 45, 50, -5, 42, 7, 7);
insert into league values(16, 'Everton', 11, 9, 18, 45, 59, -14, 42, 7, 7);
insert into league values(17, 'Derby County', 10, 12, 16, 37, 59, -22, 42, 7, 7);
insert into league values(18, 'Man City', 8, 10, 20, 41, 65, -24, 34, 7, 7);
insert into league values(19, 'Coventry City', 8, 10, 20, 36, 63, -27, 34, 7, 7);
insert into league values(20, 'Bradford City', 5, 11, 22, 30, 70, -40, 26, 7, 7);
insert into league values(1, 'Man Utd', 28, 7, 3, 97, 45, 52, 91, 6, 6);
insert into league values(2, 'Arsenal', 22, 7, 9, 73, 43, 30, 73, 6, 6);
insert into league values(3, 'Leeds Utd', 21, 6, 11, 58, 43, 15, 69, 6, 6);
insert into league values(4, 'Liverpool', 19, 10, 9, 51, 30, 21, 67, 6, 6);
insert into league values(5, 'Chelsea', 18, 11, 9, 53, 34, 19, 65, 6, 6);
insert into league values(6, 'Aston Villa', 15, 13, 10, 46, 35, 11, 58, 6, 6);
insert into league values(7, 'Sunderland', 16, 10, 12, 57, 56, 1, 58, 6, 6);
insert into league values(8, 'Leicester City', 16, 7, 15, 55, 55, 0, 55, 6, 6);
insert into league values(9, 'WestHam Utd', 15, 10, 13, 52, 53, -1, 55, 6, 6);
insert into league values(10, 'Tottenham', 15, 8, 15, 57, 49, 8, 53, 6, 6);
insert into league values(11, 'Newcastle Utd', 14, 10, 14, 63, 54, 9, 52, 6, 6);
insert into league values(12, 'Middlesbrough', 14, 10, 14, 46, 52, -6, 52, 6, 6);
insert into league values(13, 'Everton', 12, 14, 12, 59, 49, 10, 50, 6, 6);
insert into league values(14, 'Coventry City', 12, 8, 18, 47, 54, -7, 44, 6, 6);
insert into league values(15, 'Southampton', 12, 8, 18, 45, 62, -17, 44, 6, 6);
insert into league values(16, 'Derby County', 9, 11, 18, 44, 57, -13, 38, 6, 6);
insert into league values(17, 'Bradford City', 9, 9, 20, 38, 68, -30, 36, 6, 6);
insert into league values(18, 'Wimbledon', 7, 12, 19, 46, 74, -28, 33, 6, 6);
insert into league values(19, 'Sheffield Wednesday', 8, 7, 23, 38, 70, -32, 31, 6, 6);
insert into league values(20, 'Watford', 6, 6, 26, 35, 77, -42, 24, 6, 6);
insert into league values(1, 'Man Utd', 22, 13, 3, 80, 37, 43, 79, 5, 5);
insert into league values(2, 'Arsenal', 22, 12, 4, 59, 17, 42, 78, 5, 5);
insert into league values(3, 'Chelsea', 20, 15, 3, 57, 30, 27, 75, 5, 5);
insert into league values(4, 'Leeds Utd', 18, 13, 7, 62, 34, 38, 67, 5, 5);
insert into league values(5, 'WestHam Utd', 16, 9, 13, 46, 53, -7, 57, 5, 5);
insert into league values(6, 'Aston Villa', 15, 10, 13, 51, 46, 5, 55, 5, 5);
insert into league values(7, 'Liverpool', 15, 9, 14, 68, 49, 19, 54, 5, 5);
insert into league values(8, 'Derby County', 13, 13, 12, 40, 45, -5, 52, 5, 5);
insert into league values(9, 'Middlesbrough', 12, 15, 11, 48, 54, -6, 51, 5, 5);
insert into league values(10, 'Leicester City', 12, 13, 13, 40, 46, -6, 49, 5, 5);
insert into league values(11, 'Tottenham', 11, 14, 13, 47, 50, -3, 47, 5, 5);
insert into league values(12, 'Sheffield Wednesday', 13, 7, 18, 41, 42, -1, 46, 5, 5);
insert into league values(13, 'Newcastle Utd', 11, 13, 14, 48, 54, -6, 46, 5, 5);
insert into league values(14, 'Everton', 11, 10, 17, 42, 47, -5, 43, 5, 5);
insert into league values(15, 'Coventry City', 11, 9, 18, 39, 51, -12, 42, 5, 5);
insert into league values(16, 'Wimbledon', 10, 12, 16, 40, 63, -23, 42, 5, 5);
insert into league values(17, 'Southampton', 11, 8, 19, 37, 64, -27, 41, 5, 5);
insert into league values(18, 'Charlton', 8, 12, 18, 41, 56, -15, 36, 5, 5);
insert into league values(19, 'Blackburn', 7, 14, 17, 38, 52, -14, 35, 5, 5);
insert into league values(20, 'Nottingham Forest', 7, 9, 22, 35, 69, -34, 30, 5, 5);
insert into league values(1, 'Arsenal', 23, 9, 6, 68, 33, 35, 78, 4, 4);
insert into league values(2, 'Man Utd', 23, 8, 7, 73, 26, 47, 77, 4, 4);
insert into league values(3, 'Liverpool', 18, 11, 9, 68, 42, 26, 65, 4, 4);
insert into league values(4, 'Chelsea', 20, 3, 15,71, 43, 28, 63, 4, 4);
insert into league values(5, 'Leeds Utd', 17, 8, 13,  57, 46, 11, 59, 4, 4);
insert into league values(6, 'Blackburn', 16, 10, 12, 57, 52, 5, 58, 4, 4);
insert into league values(7, 'Aston Villa', 17, 6, 15, 49, 48, 1, 57, 4, 4);
insert into league values(8, 'WestHam Utd', 16, 8, 14, 56, 57, -1, 56, 4, 4);
insert into league values(9, 'Derby County', 16, 7, 15, 52, 49, 3, 55, 4, 4);
insert into league values(10, 'Leicester City', 13, 14, 11, 51, 41, 10, 53, 4, 4);
insert into league values(11, 'Coventry City', 12, 16, 10, 46, 44, 2, 52, 4, 4);
insert into league values(12, 'Southampton', 14, 6, 18, 50, 55, -5, 48, 4, 4);
insert into league values(13, 'Sheffield Wednesday', 12, 8, 18, 52, 67, -15, 44, 4, 4);
insert into league values(14, 'Tottenham', 11, 11, 16, 44, 56, -12, 44, 4, 4);
insert into league values(15, 'Newcastle Utd', 11, 11, 16, 35, 44, -9, 44, 4, 4);
insert into league values(16, 'Wimbledon', 10, 14, 14, 34, 46, -12, 44, 4, 4);
insert into league values(17, 'Everton', 9, 13, 16, 41, 56, -15, 40, 4, 4);
insert into league values(18, 'Bolton', 9, 13, 16, 41, 61, -20, 40, 4, 4);
insert into league values(19, 'Barnsley', 10, 5, 23, 37, 82, -45, 35, 4, 4);
insert into league values(20, 'Crystal Palace', 8, 9, 21, 37, 71, -34, 33, 4, 4);
insert into league values(1, 'Man Utd', 21, 12, 5, 76, 44, 32, 75, 3, 3);
insert into league values(2, 'Newcastle Utd', 19, 11, 8, 73, 40, 33, 68, 3, 3);
insert into league values(3, 'Arsenal', 19, 11, 8, 62, 32, 30, 68, 3, 3);
insert into league values(4, 'Liverpool', 19, 11, 8, 62, 37, 25, 68, 3, 3);
insert into league values(5, 'Aston Villa', 17, 10, 11, 47, 34, 13, 61, 3, 3);
insert into league values(6, 'Chelsea', 16, 11, 11, 58, 55, 3, 59, 3, 3);
insert into league values(7, 'Sheffield Wednesday', 14, 15, 9, 50, 51, -1, 57, 3, 3);
insert into league values(8, 'Wimbledon', 15, 11, 12, 49, 46, 3, 56, 3, 3);
insert into league values(9, 'Leicester City', 12, 11, 15, 46, 54, -8, 47, 3, 3);
insert into league values(10, 'Tottenham', 13, 7, 18, 44, 51, -7, 46, 3, 3);
insert into league values(11, 'Leeds Utd', 11, 13, 14, 28, 38, -10, 46, 3, 3);
insert into league values(12, 'Derby County', 11, 13, 18, 45, 58, -13, 46, 3, 3);
insert into league values(13, 'Blackburn', 9, 15, 14, 42, 43, -1, 42, 3, 3);
insert into league values(14, 'WestHam Utd', 10, 12, 16, 39, 48, -9, 42, 3, 3);
insert into league values(15, 'Everton', 10, 12, 16, 44, 57, -13, 42, 3, 3);
insert into league values(16, 'Southampton', 10, 11, 17, 50, 56, -6, 41, 3, 3);
insert into league values(17, 'Coventry City', 9, 14, 15, 38, 54, -16, 41, 3, 3);
insert into league values(18, 'Sunderland', 10, 10, 18, 35, 53, -18, 40, 3, 3);
insert into league values(19, 'Middlesbrough', 10, 12, 16, 51, 60, -9, 39, 3, 3);
insert into league values(20, 'Nottingham Forest', 6, 16, 16, 31, 59, -28, 34, 3, 3);
insert into league values(1, 'Man Utd', 25, 7, 6, 73, 35, 38, 82, 2, 2);
insert into league values(2, 'Newcastle Utd', 24, 6, 8, 66, 37, 29, 78, 2, 2);
insert into league values(3, 'Liverpool', 20, 11, 7, 70, 34, 36, 71, 2, 2);
insert into league values(4, 'Aston Villa', 18, 9, 11, 52, 35, 17, 63, 2, 2);
insert into league values(5, 'Arsenal', 17, 12, 9, 49, 32, 17, 63, 2, 2);
insert into league values(6, 'Everton', 17, 10, 11, 64, 44, 20, 61, 2, 2);
insert into league values(7, 'Blackburn', 18, 7, 13, 61, 47, 14, 61, 2, 2);
insert into league values(8, 'Tottenham', 16, 13, 9, 50, 38, 12, 61, 2, 2);
insert into league values(9, 'Nottingham Forest', 15, 13, 10, 50, 54, -4, 58, 2, 2);
insert into league values(10, 'WestHam Utd', 14, 9, 15, 43, 52, -9, 51, 2, 2);
insert into league values(11, 'Chelsea', 12, 14, 12, 46, 44, 2, 50, 2, 2);
insert into league values(12, 'Middlesbrough', 11, 10, 17, 35, 50, -15, 43, 2, 2);
insert into league values(13, 'Leeds Utd', 12, 7, 19, 40, 57, -17, 43, 2, 2);
insert into league values(14, 'Wimbledon', 10, 11, 17, 55, 70, -15, 41, 2, 2);
insert into league values(15, 'Sheffield Wednesday', 10, 10, 18, 48, 61, -13, 40, 2, 2);
insert into league values(16, 'Coventry City', 8, 14, 16, 42, 60, -18, 38, 2, 2);
insert into league values(17, 'Southampton', 9, 11, 18, 34, 52, -18, 38, 2, 2);
insert into league values(18, 'Man City', 9, 11, 18, 33, 58, -25, 38, 2, 2);
insert into league values(19, 'QPR', 9, 6, 23, 38, 57, -19, 33, 2, 2);
insert into league values(20, 'Bolton', 8, 5, 25, 39, 71, -32, 29, 2, 2);
insert into league values(1, 'Blackburn', 27, 8, 7, 80, 39, 41, 89, 1, 1);
insert into league values(2, 'Man Utd', 26, 10, 6, 77, 29, 48, 88, 1, 1);
insert into league values(3, 'Nottingham Forest', 22, 11, 9, 72, 43, 29, 77, 1, 1);
insert into league values(4, 'Liverpool', 21, 11, 10, 65, 37, 28, 74, 1, 1);
insert into league values(5, 'Leeds Utd', 20, 13, 9, 59, 38, 21, 73, 1, 1);
insert into league values(6, 'Newcastle Utd', 20, 12, 10, 67, 47, 20, 72, 1, 1);
insert into league values(7, 'Tottenham', 16, 14, 12, 66, 58, 8, 62, 1, 1);
insert into league values(8, 'QPR', 17, 9, 16, 61, 59, 2, 60, 1, 1);
insert into league values(9, 'Wimbledon', 15, 11, 16, 48, 65, -17, 56, 1, 1);
insert into league values(10, 'Southampton', 12, 18, 12, 61, 63, -2, 54, 1, 1);
insert into league values(11, 'Chelsea', 13, 15, 14, 50, 55, -5, 54, 1, 1);
insert into league values(12, 'Arsenal', 13, 12, 17, 53, 49, 4, 51, 1, 1);
insert into league values(13, 'Sheffield Wednesday', 13, 12, 17, 49, 57, -8, 51, 1, 1);
insert into league values(14, 'WestHam Utd', 13, 11, 18, 44, 48, -4, 50, 1, 1);
insert into league values(15, 'Everton', 11, 17, 14, 44, 51, -7, 50, 1, 1);
insert into league values(16, 'Coventry City', 12, 14, 16, 44, 62, -18, 50, 1, 1);
insert into league values(17, 'Man City', 12, 13, 17, 53, 64, -11, 49, 1, 1);
insert into league values(18, 'Aston Villa', 11, 15, 16, 51, 56, -5, 48, 1, 1);
insert into league values(19, 'Crystal Palace', 11, 12, 19, 34, 49, -15, 45, 1, 1);
insert into league values(20, 'Norwich City', 10, 13, 19, 37, 54, -17, 43, 1, 1);
insert into league values(21, 'Leicester City', 6, 11, 25, 45, 80, -35, 29, 1, 1);
insert into league values(22, 'Ipswich Town', 7, 6, 29, 36, 93, -57, 27, 1, 1);
insert into league values(1, 'Man Utd', 27, 11, 4, 80, 38, 42, 92, 0, 0);
insert into league values(2, 'Blackburn', 25, 9, 8, 63, 36, 27, 84, 0, 0);
insert into league values(3, 'Newcastle Utd', 23, 8, 11, 82, 41, 41, 77, 0, 0);
insert into league values(4, 'Arsenal', 18, 17, 7, 53, 28, 25, 71, 0, 0);
insert into league values(5, 'Leeds Utd', 18, 16, 8, 65, 39, 26, 70, 0, 0);
insert into league values(6, 'Wimbledon', 18, 11, 13, 56, 53, 3, 65, 0, 0);
insert into league values(7, 'Sheffield Wednesday', 16, 16, 10, 76, 54, 22, 64, 0, 0);
insert into league values(8, 'Liverpool', 17, 9, 16, 59, 55, 4, 60, 0, 0);
insert into league values(9, 'QPR', 16, 12, 14, 62, 61, 1, 60, 0, 0);
insert into league values(10, 'Aston Villa', 15, 12, 15, 46, 50, -4, 57, 0, 0);
insert into league values(11, 'Coventry City', 14, 14, 14, 43, 45, -2, 56, 0, 0);
insert into league values(12, 'Norwich City', 12, 17, 13, 65, 61, 4, 53, 0, 0);
insert into league values(13, 'WestHam Utd', 13, 13, 16, 47, 48, -11, 52, 0, 0);
insert into league values(14, 'Chelsea', 13, 12, 17, 49, 53, -4, 51, 0, 0);
insert into league values(15, 'Tottenham', 11, 12, 19, 54, 59, -5, 45, 0, 0);
insert into league values(16, 'Man City', 9, 18, 15, 38, 49, -11, 45, 0, 0);
insert into league values(17, 'Everton', 12, 8, 22, 42, 63, -21, 44, 0, 0);
insert into league values(18, 'Southampton', 12, 7, 23, 49, 66, -17, 43, 0, 0);
insert into league values(19, 'Ipswich Town', 9, 16, 17, 35, 58, -23, 43, 0, 0);
insert into league values(20, 'Sheffield Utd', 8, 18, 16, 42, 60, -18, 42, 0, 0);
insert into league values(21, 'Oldham Athletic', 9, 13, 20, 42, 68, -26, 40, 0, 0);
insert into league values(22, 'Swindon Town', 5, 15, 22, 47, 100, -53, 30, 0, 0);



