CREATE TABLE table_203_482 (id NUMBER, "year" NUMBER, "award" CLOB, "result" CLOB, "category" CLOB, "series" CLOB)

how many teen choice awards was scrubs nominate for from 2004 to 2007 ?
SELECT COUNT(*) FROM table_203_482 WHERE "award" = 'teen choice awards' AND "year" >= 2004 AND "year" <= 2007
SELECT COUNT(*) FROM "table_203_482" WHERE "award" = 'teen choice awards' AND "year" <= 2007 AND "year" >= 2004