CREATE TABLE table_name_5 (week NUMBER, date VARCHAR2)

WHAT IS THE AVERAGE WEEK WITH A DATE OF JULY 25?
SELECT AVG(week) FROM table_name_5 WHERE date = "july 25"
SELECT AVG("week") FROM "table_name_5" WHERE "date" = "july 25"