Table: defensive_stats
Columns: player
sacks
int_s
yards
average
long

Question: How many values for INT's occur with more than 0 yards, over 6 sacks, and average above 17.5?
SQL: SELECT COUNT("int_s") FROM defensive_stats WHERE "yards" > 0 AND "sacks" > 6 AND "average" > 17.5

Question: What is the sum of average values for 23 yards?
SQL: SELECT SUM("average") FROM defensive_stats WHERE "yards" = 23

Question: What is the lowest value of INT's with an average more than 25?
SQL: SELECT MIN("int_s") FROM defensive_stats WHERE "average" > 25

Question: What are the most yards for 2 sacks and an average greater than 0?
SQL: SELECT MAX("yards") FROM defensive_stats WHERE "sacks" = 2 AND "average" > 0

Question: What is the sum of values for INT'S with Mossy Cade for 0 yards and less than 3 sacks?
SQL: SELECT SUM("int_s") FROM defensive_stats WHERE "yards" = 0 AND "sacks" < 3 AND "player" = 'mossy cade'