Birth Date of 8 November 1980, and a Weight smaller than 93 has what sum of a shirt number?
CREATE TABLE table_name_6 (shirt_no INTEGER, birth_date VARCHAR, weight VARCHAR)
SELECT SUM(shirt_no) FROM table_name_6 WHERE birth_date = "8 november 1980" AND weight < 93
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_6 (shirt_no INTEGER, birth_date VARCHAR, weight VARCHAR) Question: Birth Date of 8 November 1980, and a Weight smaller than 93 has what sum of a shirt number? [/INST] SELECT SUM(shirt_no) FROM table_name_6 WHERE birth_date = "8 november 1980" AND weight < 93 </s>