what is the apps when the name is smith?
CREATE TABLE table_name_24 (apps INTEGER, name VARCHAR)
SELECT MIN(apps) FROM table_name_24 WHERE name = "smith"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_24 (apps INTEGER, name VARCHAR) Question: what is the apps when the name is smith? [/INST] SELECT MIN(apps) FROM table_name_24 WHERE name = "smith" </s>