CREATE TABLE table_203_51 (id NUMBER, "channel" CLOB, "definition" CLOB, "organisation" CLOB, "ownership" CLOB, "notes" CLOB)

how many channels are in hd ?
SELECT COUNT("channel") FROM table_203_51 WHERE "definition" = 'hd'
SELECT COUNT("channel") FROM "table_203_51" WHERE "definition" = 'hd'