Table: peter_vagenas_stats
Columns: season
club
league
apps
goals

Question: Which Major League Soccer team for the 2005 season has the lowest goals?
SQL: SELECT MIN("goals") FROM peter_vagenas_stats WHERE "league" = 'major league soccer' AND "season" = '2005'

Question: What are the average apps for the Major League Soccer team club for the Seattle Sounders FC that has goals less than 0?
SQL: SELECT AVG("apps") FROM peter_vagenas_stats WHERE "league" = 'major league soccer' AND "club" = 'seattle sounders fc' AND "goals" < 0