 AND   DENOMINATOR_VALUE IS NULL
 AND   DENOMINATOR_UNIT = 'mg';
 
--- Create consolidated denominator unit for drugs that have soluble and solid ingredients in the same drug 
+-- Create consolidated denominator unit for drugs that have soluble and solid ingredients in the same drug (if some drug-ingredient row row has amount, another - nominator)
 UPDATE ds_stage ds
    SET numerator_value = amount_value,
        numerator_unit = amount_unit,

AND   DRUG_CONCEPT_CODE = '310463'
AND   AMOUNT = 7;

--insert missing packs (only those that have => 2 components)
--AMT
INSERT INTO pc_stage
(

              JOIN concept c1 ON DENOMINATOR_UNIT_CONCEPT_ID = c1.CONCEPT_ID));

-- Remove all deprecated
--!!! Anna, how did they suppose to get here?
DELETE drug_concept_stage
WHERE concept_code IN (SELECT concept_code
                       FROM concept
