Table: qb_stats_87
Columns: player
games
comp
yards
rating

Question: What is the sum rating with more than 1 comp for mark miller?
SQL: SELECT COUNT("rating") FROM qb_stats_87 WHERE "player" = 'mark miller' AND "comp" > 1

Question: What is the games average with less than 3.8 in rating and less than 9 yards?
SQL: SELECT AVG("games") FROM qb_stats_87 WHERE "rating" < 3.8 AND "yards" < 9

Question: What is the average rating for john kidd with more than 0 yards?
SQL: SELECT AVG("rating") FROM qb_stats_87 WHERE "player" = 'john kidd' AND "yards" > 0