CREATE TABLE table_204_159 (id NUMBER, "name" CLOB, "nation" CLOB, "position" CLOB, "league apps" NUMBER, "league goals" NUMBER, "fa cup apps" NUMBER, "fa cup goals" NUMBER, "total apps" NUMBER, "total goals" NUMBER)

average number of goals scored by players from scotland
SELECT AVG("total goals") FROM table_204_159 WHERE "nation" = 'scotland'
SELECT AVG("total goals") FROM "table_204_159" WHERE "nation" = 'scotland'