CREATE TABLE table_50801 ("Week" FLOAT, "Date" CLOB, "Visitor" CLOB, "Score" CLOB, "Home" CLOB, "Attendance" CLOB, "Record" CLOB)

WHAT IS THE AVERAGE WEEK WITH A DATE OF JULY 25?
SELECT AVG("Week") FROM table_50801 WHERE "Date" = 'july 25'
SELECT AVG("Week") FROM "table_50801" WHERE "Date" = 'july 25'