how many secretary of states were under prime minister macdonald ?
CREATE TABLE table_201_27 (
    id number,
    "#" number,
    "secretary of state" text,
    "prime minister" text,
    "tenure" text
)
SELECT COUNT("secretary of state") FROM table_201_27 WHERE "prime minister" = 'macdonald'
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 many secretary of states were under prime minister macdonald ? ### Input: CREATE TABLE table_201_27 (
    id number,
    "#" number,
    "secretary of state" text,
    "prime minister" text,
    "tenure" text
) ### Response: SELECT COUNT("secretary of state") FROM table_201_27 WHERE "prime minister" = 'macdonald'