Name the sumof points for year less than 1994 and chassis of lola lc89b
CREATE TABLE table_name_47 (points INTEGER, year VARCHAR, chassis VARCHAR)
SELECT SUM(points) FROM table_name_47 WHERE year < 1994 AND chassis = "lola lc89b"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_47 (points INTEGER, year VARCHAR, chassis VARCHAR) Question: Name the sumof points for year less than 1994 and chassis of lola lc89b [/INST] SELECT SUM(points) FROM table_name_47 WHERE year < 1994 AND chassis = "lola lc89b" </s>