user: ### NOW ANSWER:
Question: What is the brigade when Al-Hamra ('Arab al-Hamra) shows for name?
Columns: ['Name', 'Date', 'Defending forces', 'Brigade', 'Population']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ["'Arab al-'Arida", 'n/a', 'n/a', 'n/a', '330 inc 180 Jews']
SQL:

assistant: SELECT "Brigade" FROM "Table" WHERE "Name" = 'Al-Hamra (''Arab al-Hamra)';