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

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'