user: ### NOW ANSWER:
Question: Name the Comp which has a Name of Smith?
Columns: ['Name', 'Rating', 'Comp', 'Long', 'Yds/game']
Types: ['text', 'real', 'real', 'real', 'real']
Sample row: ['Stull', 126.22, 181.0, 64.0, 209.5]
SQL:

assistant: SELECT "Comp" FROM "Table" WHERE "Name" = 'Smith';