Table schema:
CREATE TABLE table_name_24 (apps INTEGER, name VARCHAR)

Question: what is the apps when the name is smith?
SQL: SELECT MIN(apps) FROM table_name_24 WHERE name = "smith"