user: ### NOW ANSWER:
Question: What is the average rating for john kidd with more than 0 yards?
Columns: ['Player', 'Games', 'Comp', 'Yards', 'Rating']
Types: ['text', 'real', 'real', 'real', 'real']
Sample row: ['Jim Kelly', 12.0, 250.0, 2798.0, 83.8]
SQL:

assistant: SELECT AVG("Rating") FROM "Table" WHERE "Player" = 'john kidd' AND "Yards" > 0.0;