user: Question: What year did deputy prime minister Mariano Rajoy Brey take office?
Columns: ['Deputy Prime Minister', 'Took office', 'Left office', 'Prime Minister', 'Term', 'Party']
Types: ['text', 'real', 'text', 'text', 'text', 'text']
Sample row: ['Agustín Muñoz Grandes', 1962.0, '1967', 'Francisco Franco', "Franco's dictatorship", 'Military']
SQL:

assistant: SELECT "Took office" FROM "Table" WHERE "Deputy Prime Minister" = 'Mariano Rajoy Brey';