How many career titles does roy emerson have?
CREATE TABLE table_23408094_14 (total_career_titles VARCHAR, player VARCHAR)
SELECT total_career_titles FROM table_23408094_14 WHERE player = "Roy Emerson"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_23408094_14 (total_career_titles VARCHAR, player VARCHAR) Question: How many career titles does roy emerson have? [/INST] SELECT total_career_titles FROM table_23408094_14 WHERE player = "Roy Emerson" </s>