how long was the film schooled out before beginning blue ?
CREATE TABLE table_204_323 (
    id number,
    "year" number,
    "film" text,
    "function" text,
    "notes" text
)
SELECT (SELECT "year" FROM table_204_323 WHERE "film" = 'beginning blue') - (SELECT "year" FROM table_204_323 WHERE "film" = 'schooled')
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: how long was the film schooled out before beginning blue ? ### Input: CREATE TABLE table_204_323 (
    id number,
    "year" number,
    "film" text,
    "function" text,
    "notes" text
) ### Response: SELECT (SELECT "year" FROM table_204_323 WHERE "film" = 'beginning blue') - (SELECT "year" FROM table_204_323 WHERE "film" = 'schooled')