Name the number of titles written by adam i. lapidus
CREATE TABLE table_12030612_9 (title VARCHAR, written_by VARCHAR)
SELECT COUNT(title) FROM table_12030612_9 WHERE written_by = "Adam I. Lapidus"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_12030612_9 (title VARCHAR, written_by VARCHAR) Question: Name the number of titles written by adam i. lapidus [/INST] SELECT COUNT(title) FROM table_12030612_9 WHERE written_by = "Adam I. Lapidus" </s>