Tricky~22min
The Refill Too Soon
Pharmacy compliance flagged 6 patients who refilled a controlled 30-day prescription after only 9 days. That is a diversion red flag. A bunch of routine antibiotic refills also look "too soon" at first glance — those are fine, short courses get renewed early all the time. It is only the controlled-class refills that matter here.
Tables you'll query
patientsprescriptions
What you'll learn
JOINsDate & Time Functions