Top 20 drug occurrence quantities by count from MarketScan when the drug concentration denominator is in ‘mL’
SELECT quantity , count(*) as recs
FROM drug_exposure rx
join drug_strength s ON s.drug_concept_id = rx.drug_concept_id
join source_to_concept_map m on target_concept_id=s.drug_concept_id
and m.source_vocabulary_id = 9
where s.concentration_denom_unit=‘mL’
group by 1 order by 2 DESC
quantity count
NULL ------> 5,352,704,826
120 ------> 1,755,174,696
30 ------> 1,691,853,117
100 ------> 1,561,252,470
150 ------> 1,554,596,427
60 ------> 1,503,585,520
240 ------> 1,307,392,605
10 ------> 1,289,815,720
200 ------> 1,241,314,150
15 ------> 1,213,803,384
180 ------> 911,371,962
5 ------> 876,165,683
45 ------> 656,079,965
75 ------> 638,552,544
300 ------> 587,097,428
50 ------> 527,407,543
80 ------> 523,660,735
1 ------> 441,927,397
473 ------> 357,228,590
527 ------> 339,217,568