 
 --drug_strength
 
-select distinct drug_concept_id, 'Impossible dosages' 
+select distinct drug_concept_code, 'Impossible dosages' 
 from drug_strength_stage 
 where ( NUMERATOR_UNIT_CONCEPT_ID=8576 and DENOMINATOR_UNIT_CONCEPT_ID=8587 and NUMERATOR_VALUE / DENOMINATOR_VALUE > 1000 )
 or 


)
group by error_type
;
UNION


select distinct drug_concept_code, 'Percents in wrong place' 
from drug_strength_stage 
where (NUMERATOR_UNIT_CONCEPT_ID=8554 and DENOMINATOR_UNIT_CONCEPT_ID is not null) or AMOUNT_UNIT_CONCEPT_ID=8554

