Table: lions_passing_1979
Columns: player
games
comp
yards
rating

Question: What is the comp for games less than 2?
SQL: SELECT "comp" FROM lions_passing_1979 WHERE "games" < 2

Question: What is the highest comp for ratings less than 52.8 and yards less than 0?
SQL: SELECT MAX("comp") FROM lions_passing_1979 WHERE "rating" < 52.8 AND "yards" < 0

Question: What is the sum of yards for a 118.7 rating?
SQL: SELECT SUM("yards") FROM lions_passing_1979 WHERE "rating" = 118.7

Question: What is the highest yards for a rating larger than 52.8 and more than 13 games?
SQL: SELECT MAX("yards") FROM lions_passing_1979 WHERE "rating" > 52.8 AND "games" > 13