Table: defensive_stats_1987
Columns: player
tackles
solo
assisted
sack
yards
td_s

Question: What is the lowest Sack with a Solo of 24, with Tackles larger than 25.5, with Yards larger than 0?
SQL: SELECT MIN("sack") FROM defensive_stats_1987 WHERE "solo" = 24 AND "tackles" > 25.5 AND "yards" > 0

Question: What is the total number of Solo with a Player with sean mcinerney, and Yards larger than 0?
SQL: SELECT COUNT("solo") FROM defensive_stats_1987 WHERE "player" = 'sean mcinerney' AND "yards" > 0

Question: What is the highest Sack with an Assisted larger than 4, with TD's smaller than 0?
SQL: SELECT MAX("sack") FROM defensive_stats_1987 WHERE "assisted" > 4 AND "td_s" < 0