The pharmacy wants to know which medications are prescribed most often. Return the medication name and its prescription count for the top 10 most-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