CREATE TABLE table_6046 ("Month" TEXT, "Week" FLOAT, "Offensive" TEXT, "Defensive" TEXT, "Goalkeeper" TEXT, "Rookie" TEXT)

What was the lowest week in the month of August against Andrew Combs?
SELECT MIN("Week") FROM table_6046 WHERE "Month" = 'august' AND "Offensive" = 'andrew combs'
SELECT MIN("Week") FROM "table_6046" WHERE "Month" = 'august' AND "Offensive" = 'andrew combs'