Which scorer plays for Aldershot and has scored a total of 19 League goals?
CREATE TABLE table_name_17 (scorer VARCHAR, club VARCHAR, league_goals VARCHAR)
SELECT scorer FROM table_name_17 WHERE club = "aldershot" AND league_goals = "19"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_17 (scorer VARCHAR, club VARCHAR, league_goals VARCHAR) Question: Which scorer plays for Aldershot and has scored a total of 19 League goals? [/INST] SELECT scorer FROM table_name_17 WHERE club = "aldershot" AND league_goals = "19" </s>