Table: t_2008_terrapins_stats
Columns: player
rating
cmp
att
cmp_2
yards
int
long

Question: Which Cmp % has an Int smaller than 2 and a Cmpnsmaller than 1?
SQL: SELECT MIN("cmp_2") FROM t_2008_terrapins_stats WHERE "int" < 2 AND "cmp" < 1

Question: How many Atts that have Yards of 43 and a Long larger than 43?
SQL: SELECT SUM("att") FROM t_2008_terrapins_stats WHERE "yards" = 43 AND "long" > 43

Question: How many Ints have a Rating smaller than 87, and Yards larger than 4?
SQL: SELECT AVG("int") FROM t_2008_terrapins_stats WHERE "rating" < 87 AND "yards" > 4