Pharmacy analytics wants to know prescription durations. Calculate the number of days between start_date and end_date for each prescription. Return medication, start_date, end_date, and duration_days. Order by duration_days 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