i was asked to find the average based on two criteria which id the year and tier. like for example, what is the average cost when the year is 1985 and tier 1? (Notes: there are 1 or more record which the same year and tier but different cost)

clearer picture

ASAP

DOO UM 1 XVIIMATCHCOUGAIN AB D G Darby The 1 Cou 19 1986 Co $10.000 500.750 $11.900 $11.00 5100 $15.10 $56,00 1982 The Ther Ther Text Tier1 Ter Tier 4 The 4 Tier 4 Ti Tiera Tier 4 T Text Tier Thr There Ther The 4 101 1903 517300 7 8 9 10 11 12 1a 14 15 16 17 18 19 1W Original Data by School Year School 1985 Busine MDA 1946 Buss ( MA) 1987 bu IMA) 1968 un (MA) 1989 Buss (MA 1990 DIMA 1991 Business MBA 1992 Bress MBA 1993 IMBA) 1994 (MBA 1995 BIMBA 1996 Business 1997 Busine (MEA) Business (MA 1990 BM) 2000 MA 2001 Bus MGA 2002 business (MA) 2003 MAI 2004 Bule MA 3005 Business IMBA 2000 Buss (MA) IMA) 2008 MA Ther Tiet Thier Ter TI 19 T $18350 519,750 $21.000 $72,700 523.500 525.000 $26,260 527390 SSCO $10.00 53LNO $336,50 $350 337.500 S600 100 1998 99 2006 2001 T4 There The 21 22 28 24 25 16 17 her Tert Teft Te TE Ter Teri The 1 Ter TI 2001 2004 2004 200 2001 200 2007 Tard Al AMAisioxidatMTop-coingio D E F G H M N o 1 2 3 Dute by The TE Tier The Tier TH Ther! 5 6 T1 Tier1 1953 19 19 1989 1900 1991 et 8 9 10 11 12 1993 1990 Original Data by School Year Schael 1985 Business MBA 1986 MA) TORT Rinsiness (MA) 10 Business IMDA 199 the MAY 1990 Business MBA B. MA 1992 Business IMBA 1993 Mines (MSA) 1094 Business MBA Business IMBA 1990 Business IMBA 1997 Rusiness (MBA Business (MBA 1999 Business ( MA) 2000 Business IMSA 2001 Business MB) 2002 Business (MBA) 2001 Berness IMBA 2004 Business IMA 2000 Business IMG 2006 Nunes ( MA Fury 1995 14 15 16 17 18 19 20 21 Cou 510.000 510.750 $11.900 513.300 $1450 515350 $16, 600 $17.500 $18.550 $19.750 $21.000 $22.700 5230840 525.000 526.260 $22.250 528.500 $30.050 35100 S12650 $35.60 sayo 529.600 There Thes Tr Tier 4 Ther Tier 4 Ter The Ther4 Ther Text Therd T4 TE T4 Tier 4 The+ T 4 THE 1993 1956 15 1996 1997 19 1994 T Tier1 Tit1 Ther1 Tur1 Tier The 1 Ther1 Tiers T1 Test The1 Tier Tier 2000 2001 2002 10 2003 23 2014 25 2004 2005 2006 2007 Tier1 Tier Tert 14 AB C D E F G M 1 2 3 4 Ave Cost 1 SHIMA Hipe the 1985 5 6 7 8 1 (MA 398 M MA IMA 500 Data by Tier Year 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 9 1992 1993 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Original Data by School Year School 1985 Business (MBA) 1986 Business (MBA) 1987 Business (MBA) 1988 Business (MBA) 1989 Business (MBA) 1990 Business (MBA) 1991 Husiness (MBA) 1992 Business (MBA) Business (MBA) 1994 Business (MBA) 1995 Business (MBA) 1996 Business (MBA) 1997 Business (MBA) 1998 Business (MBA) 1999 Business (MIA) 2000 Business (MBA) 2001 Business (MBA) 2002 Business (MBA) 2003 Business (MBA) 2004 Business (MBA) 2005 Business (MIA) 2006 Business (MBA) 2002 Business (MBA) 2008 Business (MBA) Cover Data Inputs Forecast - Schools Cost Tier 510,000 Tier 4 $10.750 Tier 4 $11.900 Tier 4 $13,300 Tier 4 $14,250 Tier 4 $15.350 Tier 4 $16,400 Tier 4 $17.500 Tier 4 $18.550 Tier 4 $19,750 Tier 4 $21,000 Tier 4 $22,700 Tier 4 $23,840 Tier 4 $25,000 Tier 4 $26,200 Tier 4 $27.250 Tier 4 $28,500 Tier 4 $30,050 Tier 4 $31,800 Tier 4 $33,650 Tier 4 $35,600 Tier 4 $57,500 Tier 4 $39,600 Tier 4 $41,900 Tier 4 Forecast - Tiers Tier Tler 1 Tier 1 Tier 1 Tier 1 Tier 1 Tier 1 Tier1 Tier1 Tier 1 Tier 1 Tier 1 Tier 1 Tier1 Tier 1 Tier1 Tier 1 Tier 1 Tier1 Tier Tier1 Tier1 Tier1 Tier1 Tier 1 MA 19A SMA MA MA MA so LIMEN 2002 HDMI BOM SOM SON M SNIMA 2000 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2002 200R 200 2009