What tier had a runner-up of Lisa Raymond and a semifinalist of Sandrine Testud Mary Pierce?
CREATE TABLE table_name_46 (tier VARCHAR, semi_finalists VARCHAR, runner_up VARCHAR)
SELECT tier FROM table_name_46 WHERE semi_finalists = "sandrine testud mary pierce" AND runner_up = "lisa raymond"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_46 (tier VARCHAR, semi_finalists VARCHAR, runner_up VARCHAR) Question: What tier had a runner-up of Lisa Raymond and a semifinalist of Sandrine Testud Mary Pierce? [/INST] SELECT tier FROM table_name_46 WHERE semi_finalists = "sandrine testud mary pierce" AND runner_up = "lisa raymond" </s>