The pharmacy manager wants to know which medications are prescribed most often. Return the medication name and prescription_count for the top 5 most frequently prescribed medications.
Schema
🔑idINT
🔗visit_idINT
medicationTEXT
dosageTEXT
frequencyTEXT
start_dateTEXT
end_dateTEXT
refillsINT
postgresql
Run your query to see results
Press Ctrl + Enter to execute