Table: soccer_stats_2008
Columns: rank
goalkeeper
club
mins
shts
w_l_t

Question: What is the largest number for SHTS for the San Jose earthquakes with MINS larger than 2700?
SQL: SELECT MAX("shts") FROM soccer_stats_2008 WHERE "club" = 'san jose earthquakes' AND "mins" > 2700

Question: What is the sum of Rank when Pat Onstad was the goalkeeper?
SQL: SELECT SUM("rank") FROM soccer_stats_2008 WHERE "goalkeeper" = 'pat onstad'

Question: What is the club for the 132 SHTS?
SQL: SELECT "club" FROM soccer_stats_2008 WHERE "shts" = 132

Question: What is the largest MINS for the San Jose Earthquakes with a SHTS less than 166?
SQL: SELECT MAX("mins") FROM soccer_stats_2008 WHERE "club" = 'san jose earthquakes' AND "shts" < 166