SELECT count(*) FROM medicine WHERE FDA_approved  =  'No'
How many medicines have the FDA approval status 'No' ?
SELECT count ( * ) FROM medicine WHERE FDA_approved = 'No '
select count ( * ) from medicine where fda_approved = value
How many medicines have the FDA approval status 'No ' ?