CREATE TABLE table_51575 ("Nat." CLOB, "Name" CLOB, "Since" CLOB, "Goals" FLOAT, "Transfer fee" CLOB)

Which name had 6 goals?
SELECT "Name" FROM table_51575 WHERE "Goals" = '6'
SELECT "Name" FROM "table_51575" WHERE "Goals" = '6'