What is the brigade when Al-Hamra ('arab al-hamra) shows for name?
CREATE TABLE table_46547 (
    "Name" text,
    "Date" text,
    "Defending forces" text,
    "Brigade" text,
    "Population" text
)
SELECT "Brigade" FROM table_46547 WHERE "Name" = 'al-hamra (''arab al-hamra)'
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 brigade when Al-Hamra ('arab al-hamra) shows for name? ### Input: CREATE TABLE table_46547 (
    "Name" text,
    "Date" text,
    "Defending forces" text,
    "Brigade" text,
    "Population" text
) ### Response: SELECT "Brigade" FROM table_46547 WHERE "Name" = 'al-hamra (''arab al-hamra)'