Caso 6 - 2020

group: Caso6

Eq = {
	codeq:number, nombre:string,cant_copas:number, pais:string
	10, "Real Madrid", 26, "España"
	20, "AL-AHLY", 24, "Egipto" 
	30, "Boca Juniors", 18, "Argentina"
	40, "Milan", 18, "Italia"
	50, "Independiente", 18, "Argentina"
	60, "Barcelona", 17, "España"
	70, "Liverpool", 14, "Inglaterra"
        90,"FC Bayern de Munich", 2,"Alemania"
}

Fut = {
  nrodoc:number, paisnac:string, nya:string, fecha_nac:date
  1034, "Argentina", "Gonzalo Higuain", 1987-05-06
  2043, "Argentina", "Roman Riquelme", 1978-06-14
  3067, "Argentina", "Gabriel Milito", 1980-09-07
  4045, "Argentina", "Javier Saviola", 1979-03-10
  5089, "Argentina", "Lucas Biglia", 1986-01-30
  6305, "Argentina", "Javier Ignacio León", 1982-03-23
  7027, "Portugal", "Cristiano Ronaldo", 1985-02-05
  8067, "Brasil", "Nazario Ronaldo", 1976-09-22
  909, "Brasil", "Neymar da Silva", 1992-02-05
  1007, "Brasil", "Ronaldinho", 1980-03-21
  1100, "Brasil", "Philippe Coutinho", 1992-06-12
  1207, "Senegal", "Sadio Mané", 1992-04-10
  1366, "Egipto", "Mohamed Salah", 1984-11-12
}

P = {
codeqc:number, codeqv:number, nrodoc:number, fecha:date, monto:number 
60, 30, 2043, 2001-12-26, 8000000
30, 60, 2043, 2004-12-28, 4000000
40, 10, 8067, 2007-12-28, 80000000
90, 10, 2043, 2016-12-08,90000000
40, 60, 1007, 2008-12-28, 50000000
60, 70, 1100, 2018-12-26, 60000000
70, 20, 1366, 2017-12-24, 40000000
}

J = {
codeq:number, nrodoc:number, fechad:date, fechah:date, posic:string
30, 2043, 1999-01-01, 2001-12-25, "Enganche"
60, 2043, 2001-12-25, 2004-12-25, "Enganche"
90, 2043, 2017-12-25, 2018-12-25, "Delantero"
30, 2043, 2006-12-25, 2014-12-25, "Enganche"
10, 1034, 2005-12-25, 2010-12-25, "Delantero"
60, 4045, 2001-12-25, 2006-12-25, "Delantero"
50, 3067, 1997-12-25, 2003-12-25, "Defensor"
40, 5089, 2017-12-25, 2021-12-25, "Centrocampista"
20, 6305, 2012-12-25, 2013-12-25, "Defensor"
10,7027, 2009-12-25, 2018-12-25, "Delantero"
10, 8067, 2002-12-25, 2007-12-25, "Delantero"
40, 8067, 2007-12-29, 2008-12-25, "Delantero"
60, 909, 2013-12-25, 2017-12-25, "Delantero"
60, 1007, 2003-12-25, 2008-12-25, "Delantero"
40, 1007, 2008-12-28, 2011-12-25, "Delantero"
70, 1100, 2012-12-25, 2018-12-25, "Enganche"
60, 1100, 2018-12-28, 2019-12-25, "Enganche"
70, 1207, 2017-12-28, 2020-12-25, "Delantero"
20, 1366, 2009-12-25, 2012-12-25, "Delantero"
70, 1366, 2017-12-25, 2020-12-25, "Delantero"
}