Table: football_players_2008
Columns: position
number
name
height
weight
class
hometown
games

Question: How many players were 6'1" and from Columbia, South Carolina?
SQL: SELECT COUNT("position") FROM football_players_2008 WHERE "height" = '6''1"' AND "hometown" = 'Columbia, South Carolina'

Question: What was Trevard Lindley's number?
SQL: SELECT MAX("number") FROM football_players_2008 WHERE "name" = 'Trevard Lindley'