Which celebrity was famous for being a rapper?
CREATE TABLE table_name_23 (celebrity VARCHAR, famous_for VARCHAR)
SELECT celebrity FROM table_name_23 WHERE famous_for = "rapper"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_23 (celebrity VARCHAR, famous_for VARCHAR) Question: Which celebrity was famous for being a rapper? [/INST] SELECT celebrity FROM table_name_23 WHERE famous_for = "rapper" </s>