Table: giants_players
Columns: number
player
shoots
position
acquired
place_of_birth
joined_from

Question: What shows for shoots for craig peacock a?
SQL: SELECT "shoots" FROM giants_players WHERE "player" = 'craig peacock a'

Question: What is the average Acquired when the Number shows as 7?
SQL: SELECT AVG("acquired") FROM giants_players WHERE "number" = 7