How many medicines have the FDA approval status 'No' ?
CREATE TABLE medicine (FDA_approved VARCHAR)
SELECT COUNT(*) FROM medicine WHERE FDA_approved = 'No'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE medicine (FDA_approved VARCHAR) Question: How many medicines have the FDA approval status 'No' ? [/INST] SELECT COUNT(*) FROM medicine WHERE FDA_approved = 'No' </s>