SCHEMA:
CREATE TABLE table_name_47 (left_office VARCHAR, took_office VARCHAR, minister VARCHAR)
USER:
What is Left Office, when Took Office is "11 June 2001", and when Minister is "Mirko Tremaglia"?

QUERY:
SELECT left_office FROM table_name_47 WHERE took_office = "11 june 2001" AND minister = "mirko tremaglia"