CREATE TABLE table_32044 ("Name" CLOB, "Career" CLOB, "Caps" FLOAT, "Goals" FLOAT, "First Cap" CLOB, "Recent Cap" CLOB)

Who has a 59 cap?
SELECT "Name" FROM table_32044 WHERE "Caps" = '59'
SELECT "Name" FROM "table_32044" WHERE "Caps" = '59'