Table: draft_picks_2007
Columns: pick
round
player
free_agent_class
new_team

Question: What was the biggest pick number for the new team of Texas Rangers, in the compensation-a round?
SQL: SELECT MAX("pick") FROM draft_picks_2007 WHERE "new_team" = 'texas rangers' AND "round" = 'compensation-a'

Question: What was the pick number for the compensation-a round, for player Frank Catalanotto?
SQL: SELECT "pick" FROM draft_picks_2007 WHERE "round" = 'compensation-a' AND "player" = 'frank catalanotto'

Question: Which new team has a compensation-a round, and Frank Catalanotto as a player?
SQL: SELECT "new_team" FROM draft_picks_2007 WHERE "round" = 'compensation-a' AND "player" = 'frank catalanotto'

Question: What was the free agent class, with a pick less than 38?
SQL: SELECT "free_agent_class" FROM draft_picks_2007 WHERE "pick" < 38