CREATE TABLE table_name_51 (rating INT, player VARCHAR, yards VARCHAR)

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