what is the sum of the member when the saros is more than 127, gamma is less than 1.1508 and the magnitude is 0.742?
CREATE TABLE table_name_11 (member INTEGER, magnitude VARCHAR, saros VARCHAR, gamma VARCHAR)
SELECT SUM(member) FROM table_name_11 WHERE saros > 127 AND gamma < 1.1508 AND magnitude = 0.742
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_11 (member INTEGER, magnitude VARCHAR, saros VARCHAR, gamma VARCHAR) Question: what is the sum of the member when the saros is more than 127, gamma is less than 1.1508 and the magnitude is 0.742? [/INST] SELECT SUM(member) FROM table_name_11 WHERE saros > 127 AND gamma < 1.1508 AND magnitude = 0.742 </s>