Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_name_9 ( att INTEGER, yards VARCHAR, comp VARCHAR )

### Question ###
For the player with yards less than 138, and Comp more than 0, what was the highest Att.?

### Accurate SQL ###

SELECT MAX(att) FROM table_name_9 WHERE yards < 138 AND comp > 0