Name the Comp which has a Name of smith?
CREATE TABLE table_43988 (
    "Name" text,
    "Rating" real,
    "Comp" real,
    "Long" real,
    "Yds/game" real
)
SELECT "Comp" FROM table_43988 WHERE "Name" = 'smith'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Name the Comp which has a Name of smith? ### Input: CREATE TABLE table_43988 (
    "Name" text,
    "Rating" real,
    "Comp" real,
    "Long" real,
    "Yds/game" real
) ### Response: SELECT "Comp" FROM table_43988 WHERE "Name" = 'smith'