CREATE TABLE table_74923 ("Game" FLOAT, "November" FLOAT, "Opponent" CLOB, "Score" CLOB, "Record" CLOB, "Points" FLOAT)

What is the highest November that has a game less than 12, and @ detroit red wings as the opponent?
SELECT MAX("November") FROM table_74923 WHERE "Game" < '12' AND "Opponent" = '@ detroit red wings'
SELECT MAX("November") FROM "table_74923" WHERE "Game" < '12' AND "Opponent" = '@ detroit red wings'