The controlled substances team wants to audit prescriptions with many refills. Find all prescriptions where refills >= 5. Return medication, dosage, frequency, and refills, ordered by refills 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