user: ### NOW ANSWER:
Question: What name has the role of Midfielder for 1999-2003?
Columns: ['Name', 'Country', 'Role', 'Period', 'Teams']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Radhouane Abbes', 'Algeria', 'Defender', '1987-1988 & 1989-1990', 'Montpellier HSC']
SQL:

assistant: SELECT "Name" FROM "Table" WHERE "Role" = 'Midfielder' AND "Period" = '1999-2003';