The pharmacy wants a compact view of all medications each patient takes. Use GROUP_CONCAT to list all distinct medications per patient. Return patient full name (first_name || ' ' || last_name) as patient_name and medications. Order by patient last name. Use a subquery to get distinct medications before concatenating.