What is the overall number for Louisiana Tech college, and a pick more than 10?
CREATE TABLE table_name_59 (overall INTEGER, college VARCHAR, pick__number VARCHAR)
SELECT SUM(overall) FROM table_name_59 WHERE college = "louisiana tech" AND pick__number > 10
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_59 (overall INTEGER, college VARCHAR, pick__number VARCHAR) Question: What is the overall number for Louisiana Tech college, and a pick more than 10? [/INST] SELECT SUM(overall) FROM table_name_59 WHERE college = "louisiana tech" AND pick__number > 10 </s>