CREATE TABLE table_55743 ("Name" CLOB, "Country" CLOB, "Type" CLOB, "Moving from" CLOB, "Transfer window" CLOB, "Transfer fee" CLOB)

Name the country for pieroni
SELECT "Country" FROM table_55743 WHERE "Name" = 'pieroni'
SELECT "Country" FROM "table_55743" WHERE "Name" = 'pieroni'