CREATE TABLE table_204_27 (id NUMBER, "name" CLOB, "position" CLOB, "year" CLOB, "league\ apps" NUMBER, "league\ goals" NUMBER, "total\ apps" NUMBER, "total\ goals" NUMBER, "notes" CLOB)

how many total goals did kit lawlor score from 1950 to 1954 ?
SELECT "total\ngoals" FROM table_204_27 WHERE "name" = 'kit lawlor' AND "year" = '1950-1954'
SELECT "total\ngoals" FROM "table_204_27" WHERE "name" = 'kit lawlor' AND "year" = '1950-1954'