The pharmacy wants to identify one-time prescriptions that have no refills. Return the medication, dosage, frequency, and start_date for prescriptions where refills is 0, ordered by start_date descending.
Schema
🔑idINT
🔗visit_idINT
medicationTEXT
dosageTEXT
frequencyTEXT
start_dateTEXT
end_dateTEXT
refillsINT
postgresql
Run your query to see results
Press Ctrl + Enter to execute