Table: union_matches
Columns: year
competition
club
nation
result

Question: What shows for nation when the Competition is preseason, Year less than 2011, and a Club of chivas de guadalajara?
SQL: SELECT "nation" FROM union_matches WHERE "competition" = 'preseason' AND "year" < 2011 AND "club" = 'chivas de guadalajara'

Question: What was the Result for the club universidad de guadalajara?
SQL: SELECT "result" FROM union_matches WHERE "club" = 'club universidad de guadalajara'

Question: What is the Nation with 2012 as the year, and a Competition of preseason, and a Result of w 0–3?
SQL: SELECT "nation" FROM union_matches WHERE "year" = 2012 AND "competition" = 'preseason' AND "result" = 'w 0–3'

Question: What is the average Year when the Competition was friendly, and a Club of everton?
SQL: SELECT AVG("year") FROM union_matches WHERE "competition" = 'friendly' AND "club" = 'everton'

Question: What is the Competition when the Club was costa rica u-20?
SQL: SELECT "competition" FROM union_matches WHERE "club" = 'costa rica u-20'

Question: What is the Club of mexico, Year of 2010, and a Competition of preseason, and a Result of w 0–1?
SQL: SELECT "club" FROM union_matches WHERE "nation" = 'mexico' AND "year" = 2010 AND "competition" = 'preseason' AND "result" = 'w 0–1'