CREATE TABLE table_name_47 (left_office VARCHAR, took_office VARCHAR, minister VARCHAR)

What is Left Office, when Took Office is '11 June 2001', and when Minister is 'Mirko Tremaglia'?
SELECT left_office FROM table_name_47 WHERE took_office = "11 june 2001" AND minister = "mirko tremaglia"
SELECT "left_office" FROM "table_name_47" WHERE "11 june 2001" = "took_office" AND "minister" = "mirko tremaglia"