CREATE TABLE table_203_643 (id NUMBER, "year" NUMBER, "award" CLOB, "group" CLOB, "result" CLOB, "notes" CLOB)

how many teen choice awards has he been nominated for ?
SELECT COUNT(*) FROM table_203_643 WHERE "award" = 'teen choice awards'
SELECT COUNT(*) FROM "table_203_643" WHERE "award" = 'teen choice awards'