     GROUP BY s_concept_code
     HAVING count (*) > 1)
 ORDER BY s_concept_code
-;
-
---Mapping to 0
-SELECT *
-FROM cap_breast_mapping
-WHERE concept_code is null
 ;
 
 -- Not perfect mapping of CAP Variables

on a.s_concept_code=split_part(b.Item_Ckey,'.',1)
AND a.concept_code != b.ConceptID
;

-- DROP TABLE cap_breast_mapping;
CREATE UNLOGGED TABLE cap_breast_mapping
(

    WHERE j2.s_concept_code=j1.s_concept_code
                  );

--Mapping to 0
SELECT *
FROM cap_breast_mapping
WHERE concept_code is null
;

--'Maps to' mapping to abnormal domains
with tab as (
    SELECT DISTINCT s.*
