what is the number of chiefs that are listed as foreign service officers ?
CREATE TABLE table_203_760 (
    id number,
    "name" text,
    "state" text,
    "status" text,
    "title" text,
    "appointment" text,
    "credentials\npresented" text,
    "termination\nof mission" text,
    "notes" text
)
SELECT COUNT("name") FROM table_203_760 WHERE "status" = 'foreign service officer'
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 number of chiefs that are listed as foreign service officers ? ### Input: CREATE TABLE table_203_760 (
    id number,
    "name" text,
    "state" text,
    "status" text,
    "title" text,
    "appointment" text,
    "credentials\npresented" text,
    "termination\nof mission" text,
    "notes" text
) ### Response: SELECT COUNT("name") FROM table_203_760 WHERE "status" = 'foreign service officer'