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

Question: How many solo tackles for the player with over 0 TDs and over 0 sacks?
SQL: SELECT MIN("solo") FROM kcb_2007_player_stats WHERE "td_s" > 0 AND "sack" > 0

Question: How many sacks for the player with over 1 tackle, under 3 assisted tackles, and over 0 yards?
SQL: SELECT COUNT("sack") FROM kcb_2007_player_stats WHERE "tackles" > 1 AND "assisted" < 3 AND "yards" > 0