-- Database schema
| medicine : id [ INT ] primary_key , name [ TEXT ] , Trade_Name [ TEXT ] , FDA_approved [ TEXT ] | enzyme : id [ INT ] primary_key , name [ TEXT ] , Location [ TEXT ] , Product [ TEXT ] , Chromosome [ TEXT ] , OMIM [ INT ] , Porphyria [ TEXT ] | medicine_enzyme_interaction : enzyme_id [ INT ] primary_key medicine_enzyme_interaction.enzyme_id = enzyme.id , medicine_id [ INT ] medicine_enzyme_interaction.medicine_id = medicine.id , interaction_type [ TEXT ] |
-- -- How many medicines have the FDA approval status 'No' ?

SELECT count(*) FROM medicine WHERE FDA_approved  =  'No';