CREATE TABLE table_name_52 (rec NUMBER, yards VARCHAR2, s_touchdown VARCHAR2)

Which rec has Yards of 192, and a Touchdown smaller than 1?
SELECT AVG(rec) FROM table_name_52 WHERE yards = 192 AND s_touchdown < 1
SELECT AVG("rec") FROM "table_name_52" WHERE "s_touchdown" < 1 AND "yards" = 192