Table: defensive_stats
Columns: name
gp_gs
solo
ast
total
tfl_yds
no_yds
brup
qbh
no_yds_2
avg
td
long
rcv_yds
ff
blkd_kick

Question: How many tackle assists for the player who averages 23.7?
SQL: SELECT "ast" FROM defensive_stats WHERE "avg" = '23.7'

Question: How many players named jake flaherty?
SQL: SELECT COUNT("solo") FROM defensive_stats WHERE "name" = 'Jake Flaherty'

Question: What is the total brup for the team?
SQL: SELECT "brup" FROM defensive_stats WHERE "name" = 'Total'

Question: What is the largest number of tds scored for a player?
SQL: SELECT MAX("td") FROM defensive_stats

Question: How many yards for the player with tfl-yds of 2.5-4?
SQL: SELECT "no_yds_2" FROM defensive_stats WHERE "tfl_yds" = '2.5-4'