CREATE TABLE table_47497 ("Position" FLOAT, "Team" TEXT, "Played" FLOAT, "Drawn" FLOAT, "Lost" FLOAT, "Goals For" FLOAT, "Goals Against" FLOAT, "Goal Difference" TEXT, "Points 1" TEXT)

What is the goal difference for the team from Chorley?
SELECT "Goal Difference" FROM table_47497 WHERE "Team" = 'chorley'
SELECT "Goal Difference" FROM "table_47497" WHERE "Team" = 'chorley'