-- mine
SELECT * FROM intersections_cr;
--a) attributes, morphology
--b) attributes, topography
SELECT * FROM MORPH_TO_SN_2_1;
SELECT * FROM ICDO_TOPOLOG;
--2) unmapped attributes combinatiobns by WHO
SELECT wc.* FROM WHO_CLEAN wc
left join intersections_cr cr ON
wc.MORPH_CODE = cr.MORPHOLOGY_CODE AND
wc.TOPO_CODE = cr.TOPOGRAPHY_CODE

WHERE cr.concept_id IS NULL

--2) unmapped attributes combinatiobns by Seer
SELECT cr.* FROM WHO_TOPO_MORPHO wc
left join INTERSECTIONS_CR  cr ON
wc.MORPH_CODE = cr.MORPHOLOGY_CODE AND
wc.TOPO_CODE = cr.TOPOGRAPHY_CODE;

WHERE cr.concept_id IS NULL

--3) Unmapped disorders, which are not present in WHO
SELECT cr.* FROM WHO_CLEAN wc
right join INTERSECTIONS_CR  cr ON
wc.MORPH_CODE = cr.MORPHOLOGY_CODE AND
wc.TOPO_CODE = cr.TOPOGRAPHY_CODE;
WHERE wc.morph_code IS NULL
--3) Unmapped disorders, which are not present in Seer
SELECT cr.* FROM WHO_TOPO_MORPHO wc
join INTERSECTIONS_CR  cr ON
wc.MORPH_CODE = cr.MORPHOLOGY_CODE AND
wc.TOPO_CODE = cr.TOPOGRAPHY_CODE;
WHERE wc.morph_code IS NULL

/*
select cr.* from WHO_CLEAN wc
join INTERSECTIONS_CR  cr on
wc.MORPH_CODE = cr.MORPHOLOGY_CODE and
wc.TOPO_CODE = cr.TOPOGRAPHY_CODE;

select cr.* from WHO_TOPO_MORPHO wc
join INTERSECTIONS_CR  cr on
wc.MORPH_CODE = cr.MORPHOLOGY_CODE and
wc.TOPO_CODE = cr.TOPOGRAPHY_CODE;
*/