which drug dosage flavor is the flavor of the manufactured drug form with the latest marketing end date?
(ARGMAX medicine.drug_dosage_flavor (JOIN (R medicine.manufactured_drug_form.flavor) medicine.manufactured_drug_form.marketing_end_date))