CREATE TABLE table_46010 ("Nat." CLOB, "Name" CLOB, "Since" CLOB, "App ( L/C/E ) " CLOB, "Goals ( L/C/E ) " CLOB, "Ends" FLOAT, "Transfer fee" CLOB)

Who has a nationality of GRE and an App(L/C/E) of 49 (40/8/1)?
SELECT "Name" FROM table_46010 WHERE "Nat." = 'gre' AND "App(L/C/E)" = '49 (40/8/1)'
SELECT "Name" FROM "table_46010" WHERE "App(L/C/E)" = '49 (40/8/1)' AND "Nat." = 'gre'