Table: player_stats_8
Columns: player
position
round
overall
mlb_team

Question: What position was less than 421 overall played by Matt Clark?
SQL: SELECT "position" FROM player_stats_8 WHERE "overall" < 421 AND "player" = 'matt clark'

Question: What was the lowest overall for Louis Coleman?
SQL: SELECT MIN("overall") FROM player_stats_8 WHERE "player" = 'louis coleman'

Question: What round did Matt Clark play?
SQL: SELECT "round" FROM player_stats_8 WHERE "player" = 'matt clark'

Question: Which position was more than 421 overall for the St. Louis Cardinals?
SQL: SELECT "position" FROM player_stats_8 WHERE "overall" > 421 AND "mlb_team" = 'st. louis cardinals'

Question: What round was less than 545 overall for San Francisco Giants?
SQL: SELECT "round" FROM player_stats_8 WHERE "overall" < 545 AND "mlb_team" = 'san francisco giants'