what is the total number of shows sophie colguhoun appeared in ?
CREATE TABLE table_204_903 (
    id number,
    "title" text,
    "character" text,
    "broadcaster" text,
    "episodes" number,
    "date" number
)
SELECT COUNT(*) FROM table_204_903
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: what is the total number of shows sophie colguhoun appeared in ? ### Input: CREATE TABLE table_204_903 (
    id number,
    "title" text,
    "character" text,
    "broadcaster" text,
    "episodes" number,
    "date" number
) ### Response: SELECT COUNT(*) FROM table_204_903