CREATE TABLE table_name_66 (tie_no NUMBER, attendance VARCHAR2)

what is the tie no when the attendance is 126?
SELECT AVG(tie_no) FROM table_name_66 WHERE attendance = 126
SELECT AVG("tie_no") FROM "table_name_66" WHERE "attendance" = 126