what flavor with the latest marketing end date is used to manufacture drug dosage flavor?
(ARGMAX medicine.drug_dosage_flavor (JOIN (R medicine.manufactured_drug_form.flavor) medicine.manufactured_drug_form.marketing_end_date))