CREATE TABLE table_204_323 (id NUMBER, "year" NUMBER, "film" CLOB, "function" CLOB, "notes" CLOB)

how long was the film schooled out before beginning blue ?
SELECT (SELECT "year" FROM table_204_323 WHERE "film" = 'beginning blue') - (SELECT "year" FROM table_204_323 WHERE "film" = 'schooled')
SELECT (SELECT "year" FROM "table_204_323" WHERE "film" = 'beginning blue') - (SELECT "year" FROM "table_204_323" WHERE "film" = 'schooled')