CREATE TABLE table_name_97 (attendance INT, loss VARCHAR)

Loss of de la rosa (8 8) has what average attendance?
SELECT AVG(attendance) FROM table_name_97 WHERE loss = "de la rosa (8–8)"
SELECT AVG("attendance") FROM "table_name_97" WHERE "de la rosa (8–8)" = "loss"