what are the four most frequently ordered medications?
select t1.drug from ( select prescriptions.drug, dense_rank() over ( order by count(*) desc ) as c1 from prescriptions group by prescriptions.drug ) as t1 where t1.c1 <= 4