Table: storm_2007_stats
Columns: player
rec
yards
avg
td_s
long

Question: What was the average for the player that scored 116 yards and had TD's less than 1?
SQL: SELECT COUNT("avg") FROM storm_2007_stats WHERE "yards" = 116 AND "td_s" < 1

Question: What was the lowest recorded record for a player with an average larger than 13?
SQL: SELECT MIN("rec") FROM storm_2007_stats WHERE "avg" > 13

Question: How many yards did Hank Edwards make when he had TD's of 1 and an average higher than 13?
SQL: SELECT COUNT("yards") FROM storm_2007_stats WHERE "td_s" = 1 AND "player" = 'hank edwards' AND "avg" > 13

Question: How many yards were averaged by the player that had a higher than 13 average with less than 18 long?
SQL: SELECT AVG("yards") FROM storm_2007_stats WHERE "long" < 18 AND "avg" > 13

Question: What is the highest number of yards recorded for a player that had more than 4 TD's?
SQL: SELECT MAX("yards") FROM storm_2007_stats WHERE "td_s" > 4