Table: stull
Columns: name
rating
comp
long
yds_game

Question: Name the Comp which has a Name of smith?
SQL: SELECT "comp" FROM stull WHERE "name" = 'smith'

Question: Name the sum of Comp which has a Yds/game smaller than 209.5,brytus Name, and a Rating smaller than 100?
SQL: SELECT SUM("comp") FROM stull WHERE "yds_game" < 209.5 AND "name" = 'brytus' AND "rating" < 100

Question: Name the highest Comp which has a Yds/game larger than 0, bostick, and a Rating smaller than 91.77?
SQL: SELECT MAX("comp") FROM stull WHERE "yds_game" > 0 AND "name" = 'bostick' AND "rating" < 91.77