user: ### NOW ANSWER:
Question: Tell me the period for Red Rock
Columns: ['Camp', 'Place', 'Province', 'Location', 'Period']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['10', 'Chatham', 'Ontario', '260 km southwest of Toronto', '1944 1945-1946']
SQL:

assistant: SELECT "Period" FROM "Table" WHERE "Place" = 'Red Rock';