Table: lions_passing_stats
Columns: player
att
comp
yards
rating

Question: What was the Comp average, having Gino Guidugli as a player and a rating of more than 92.2?
SQL: SELECT AVG("comp") FROM lions_passing_stats WHERE "player" = 'gino guidugli' AND "rating" > 92.2

Question: For the player with yards less than 138, and Comp more than 0, what was the highest Att.?
SQL: SELECT MAX("att") FROM lions_passing_stats WHERE "yards" < 138 AND "comp" > 0