CREATE TABLE table_43988 ("Name" TEXT, "Rating" FLOAT, "Comp" FLOAT, "Long" FLOAT, "Yds/game" FLOAT)

Name the Comp which has a Name of smith?
SELECT "Comp" FROM table_43988 WHERE "Name" = 'smith'
SELECT "Comp" FROM "table_43988" WHERE "Name" = 'smith'