CREATE TABLE table_8444 ("Name" CLOB, "Country" CLOB, "Role" CLOB, "Period" CLOB, "Teams" CLOB)

What name has the role of midfielder for 1999-2003?
SELECT "Name" FROM table_8444 WHERE "Role" = 'midfielder' AND "Period" = '1999-2003'
SELECT "Name" FROM "table_8444" WHERE "Period" = '1999-2003' AND "Role" = 'midfielder'