CREATE TABLE table_204_323 (id DECIMAL, "year" DECIMAL, "film" TEXT, "function" TEXT, "notes" TEXT)

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')