Table: t_2007_nashville_kats_player
Columns: player
car
yards
avg
td_s
long

Question: How many carries for jeff smoker?
SQL: SELECT SUM("car") FROM t_2007_nashville_kats_player WHERE "player" = 'jeff smoker'

Question: How many average carries for the player with 3 as a long?
SQL: SELECT AVG("car") FROM t_2007_nashville_kats_player WHERE "long" = '3'