Table schema:
CREATE TABLE table_name_97 (comp INTEGER, rating VARCHAR, yards VARCHAR)

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