what are the top three most commonly prescribed medicines since 3 years ago?
select t1.drug from ( select prescriptions.drug, dense_rank() over ( order by count(*) desc ) as c1 from prescriptions where datetime(prescriptions.startdate) >= datetime(current_time,'-3 year') group by prescriptions.drug ) as t1 where t1.c1 <= 3