SELECT count(*) FROM medicine WHERE FDA_approved  =  'No'
How many medicines were not approved by the FDA?
SELECT count ( * ) FROM medicine WHERE FDA_approved = 'No '
select count ( * ) from medicine where fda_approved = value
How many medicines were not approved by the FDA ?