CREATE TABLE table_47215 ("Scorer" CLOB, "Club" CLOB, "League goals" CLOB, "FA Cup goals" FLOAT, "League Cup goals" FLOAT, "Total" FLOAT)

Which scorer plays for Aldershot and has scored a total of 19 League goals?
SELECT "Scorer" FROM table_47215 WHERE "Club" = 'aldershot' AND "League goals" = '19'
SELECT "Scorer" FROM "table_47215" WHERE "Club" = 'aldershot' AND "League goals" = '19'