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
Investigate this case →