CREATE TABLE table_23873 ("Game" FLOAT, "Date" CLOB, "Opponent" CLOB, "Result" CLOB, "Tar Heels points" FLOAT, "Opponents" FLOAT, "Record" CLOB)

How many times were Duke the opponents?
SELECT COUNT("Opponents") FROM table_23873 WHERE "Opponent" = 'Duke'
SELECT COUNT("Opponents") FROM "table_23873" WHERE "Opponent" = 'Duke'