CREATE TABLE table_4487 ("Region" CLOB, "Operator" CLOB, "Licence award date" CLOB, "On air date" CLOB, "Closure date" CLOB)

What was the operator of the ensemble from Yorkshire?
SELECT "Operator" FROM table_4487 WHERE "Region" = 'yorkshire'
SELECT "Operator" FROM "table_4487" WHERE "Region" = 'yorkshire'