user: ### NOW ANSWER:
Question: What tier had a runner-up of Lisa Raymond and a semifinalist of Sandrine Testud Mary Pierce?
Columns: ['Week of', 'Tier', 'Winner', 'Runner-up', 'Semi finalists']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['10 July', 'Tier IV', 'Irina Spîrlea 7–6, 6–2', 'Sabine Hack', 'Natalia Medvedeva Barbara Schett']
SQL:

assistant: SELECT "Tier" FROM "Table" WHERE "Semi finalists" = 'Sandrine Testud Mary Pierce' AND "Runner-up" = 'Lisa Raymond';